On Mon, Jun 11, 2012 at 8:35 PM, Chen, Zon <[email protected]>wrote:
> 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?
>
Sounds more like something in the edit ticket script, not your report.
Can you send any additional detail?
>
>
> 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
>
--
D. Richard Hipp
[email protected]
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
