Hi,
The default tickets with comments report doesn't seem to work.
(The default examples don't seem to match the default schema)
I'd appreciate it if list members could let me know if this works for them:
--
select
CASE WHEN status IN ('new','active') THEN '#f2dcdc'
WHEN status='review' THEN '#e8e8bd'
WHEN status='fixed' THEN '#cfe8bd'
WHEN status='tested' THEN '#bde5d6'
WHEN status='defer' THEN '#cacae5'
ELSE '#c8c8c8' END as 'bgcolor',
substr(t.tkt_uuid,1,10) AS '#',
datetime(t.tkt_mtime) AS 'mtime',
t.type,
t.subsystem,
group_concat((tc.icomment || '<br> - '|| tc.login || ' - ' ||
datetime(tc.tkt_mtime)),'<br><br>') as '_comments'
FROM ticket t, ticketchng tc
WHERE t.status<>"Closed" AND t.tkt_id IN (SELECT tc.tkt_id FROM ticketchng )
GROUP BY t.tkt_id
ORDER BY datetime(t.tkt_mtime) DESC
---
Sent from my iPhone
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
