Re: [Trac] Help with report of tickets by a user

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 29.08.2012 23:54, schrieb Steffen Hoffmann: > Am 22.08.2012 04:33, schrieb Albert Chin: >> 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 lef

Re: [Trac] Help with report of tickets by a user

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 22.08.2012 04:33, schrieb Albert Chin: > 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

[Trac] Help with report of tickets by a user

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__