Actually, I was thinking about something as simple as a row number in the view but this is even better.
Thanks, Jacek 2010/1/22 Doug Currie <[email protected]> > > 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 >
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
