Hi, I've written a report to list unassigned open tickets, code below.
However, it seems that if I make any changes to the ticket, such as adding a
comment or altering its priority, it will no longer appear in this report, even
if it's still Unassigned and Open.
Also, when the report is displayed, the "priority" column is always blank,
despite the tickets having a priority.
Am I doing something wrong?
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,
assigned_to,
severity,
priority,
title
FROM ticket
WHERE assigned_to='Unassigned' AND status != 'Closed'
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
