I have a "master" queue where almost everyone sends requests. A clerk looks at the tickets there and then places them in a different queue for processing. I'd like to have a query/report that shows the ticket, the queue it is currently in, and the queue it originated from if different from the current queue.
The Ticket table only has the current queue, and I can't find any obvious way to join Transactions. Hints or better ideas? -- Ernesto Hernández-Novich - Linux 2.6.18 i686 - Unix: Live free or die! Geek by nature, Linux by choice, Debian of course. If you can't aptitude it, it isn't useful or doesn't exist. GPG Key Fingerprint = 438C 49A2 A8C7 E7D7 1500 C507 96D6 A3D6 2F4C 85E3 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
