Hi. I need help designing a report to show all tickets where the user
is the owner, reporter, or tickets they have not created but tickets
they have left a comment on. It's the last part that's tricky. I can
accomplish the first two with:
SELECT p.value AS __color__,
t.milestone AS __group__,
id AS ticket, t.type AS type, owner, reporter,
time as created, changetime AS modified
FROM ticket t, enum p
WHERE owner = 'gary' OR reporter = 'gary'
ORDER BY t.milestone, p.value, t.type, t.time
I am running 0.12.1. Any help greatly appreciated.
--
albert chin ([email protected])
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
