On Fri, Jan 22, 2010 at 11:32:37AM +0000, Jacek Cała wrote: > Hi, > 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. > � Jacek
________________________________________________________ does not add line numbers though may be useful ... I copied the 'All tickets' to make 'Open tickets' and 'Closed tickets' reports, e.g. simple change of adding where status = 'Open' 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', substr(tkt_uuid,1,10) AS '#', datetime(tkt_mtime) AS 'mtime', type, status, subsystem, title FROM ticket where status = 'Open' I suppose you could add counts of how many records are found also. ~Michael
_______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users