> I noticed Dmitry has an option for listing "All open tickets". What > would be the SQL query statement for achieving that ?
I use the following SQL: SELECT '#f2dcdc' as 'bgcolor', substr(tkt_uuid,1,10) AS '#', datetime(tkt_mtime) AS 'mtime', type, status, subsystem, title FROM ticket WHERE status = 'Open' Actually, you can remove 'status' from select, since it's always 'Open'. -- Sincerely Yours, Dmitry Chestnykh Coding Robots http://www.codingrobots.com [email protected] _______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
