On Tue, Jan 11, 2011 at 9:08 PM, Ron Wilson <ronw.m...@gmail.com> wrote:
> I am new to Fossil and have been experimenting with configuring it.
>
> then I updated the SQL:
> SELECT
> CASE WHEN status='New' THEN '#f2dcdc'
> WHEN status='Accepted' THEN '#f2dcdc'
> WHEN status='Planned' THEN '#f2dcdc'
> WHEN status='Review' THEN '#e8e8e8'
> WHEN status='Implemented' THEN '#cfe8bd'
> WHEN status='Tested' THEN '#bde5d6'
> WHEN status='Deferred' THEN '#cacae5'
> ELSE '#c8c8c8' END AS 'bgcolor',
>
Add here:
status AS status,
To see what is really in your "status" field.
> substr(tkt_uuid,1,10) AS '#',
> datetime(tkt_mtime) AS 'mtime',
> type,
> status,
> subsystem,
> title,
> comment AS '_comments'
> FROM ticket
>
> Everything loos as if it should work, but it always chooses the ELSE
> color (#c8c8c8).
>
> Any hints what I did wrong?
> _______________________________________________
> fossil-users mailing list
> fossil-users@lists.fossil-scm.org
> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
