-----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 left a comment on. It's the last part that's tricky. [...] > This is one is a more appropriate report SQL statement, at least to show > > "(current) user is owner or reporter" [...] > > About the comment, this is in another table, ticket_change. I'm just > looking at it. Will keep you updated, if I see a way to do this too.
See http://stackoverflow.com/questions/12187847 for a possible solution, that covers all three of your requirements: reporter, ticket owner (both from 'ticket') as well as comment author (from 'ticket_change') and works so without multiple entries per ticket. This last aspect seems likely the most tricky one, not the inclusion of comment authors in general. Hope this helps. Sincerely, Steffen Hoffmann -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlA+pu0ACgkQ31DJeiZFuHfJvQCgjk5Zzd8twXGzIPEfRQbVIzac aZYAni5BahJEZBaF9wHpq7pLB8gkrtMD =HB+g -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
