I have a custom field that is shared by both queues in our RT database: CONVreq.
Of course it isn't available in the query builder 'display columns'
section because I haven't limited the query to include 'queue'.
No problem; I was able to add it to the list of fields displayed by
putting this in lower box of the Advanced view:
'__CustomField.{CONVreq}__',
Now, about the 'order by' clause... It's the same problem, but I
don't have any examples of how to specify ORDER BY in the Advanced
query builder.
Any help?
Thanks,
Phil Lawrence
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
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