In SQL, you have to use % as a wildcard when doing a like query. If GL is a prefix then you want to do Queue LIKE 'GL%'.
Thank you, Micah Gersten Internal Developer onShore Networks www.onshore.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Crocker Sent: Thursday, March 27, 2008 3:13 PM To: rt Users Subject: [rt-users] RT Query - Ticket SQL To all, I don't believe I have seen any threads on this question, but if so, please forgive me. I just re-named a bunch of queues to include a prefix so that if a particular group works with tickets in several queues, they can create a query that asks for queues LIKE "XX-" instead of listing each queue they want to search. So, I went to "advanced" and change the SQL from (Queue = 'GL' OR Queue = 'AP' etc.) to Queue LIKE 'FS-' and I got garbage. Didn't work at all. I tried a few variations like (Queue LIKE 'FS') but to no avail. Does anyone have a list of the available 'Ticket SQL' commands? Has anyone tried this and been successful? If so, what did you code? Thanks. Kenn LBNL _______________________________________________ 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 No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.0/1344 - Release Date: 3/26/2008 8:52 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.0/1344 - Release Date: 3/26/2008 8:52 AM _______________________________________________ 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
