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
