On Jan 22, 2010, at 6:32 AM, Jacek Cała wrote:
> Do you have any idea how to add numbering to the list of tickets. It would be
> nice to have a quantitative view on the solved/unsolved issues. I was
> skimming through the sqllite manual but couldn't find anything usable.
SELECT
CASE WHEN status IN ('Open','Verified') THEN '#f2dcdc'
WHEN status='Review' THEN '#e8e8e8'
WHEN status='Fixed' THEN '#cfe8bd'
WHEN status='Tested' THEN '#bde5d6'
WHEN status='Deferred' THEN '#cacae5'
ELSE '#c8c8c8' END AS 'bgcolor',
status,
count (*) AS 'count'
FROM ticket GROUP BY status
e
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
