[rt-users] RT Query - Ticket SQL

Micah Gersten micah at onshore.com
Thu Mar 27 16:39:41 EDT 2008


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: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] 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: sales at bestpractical.com


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
 




More information about the rt-users mailing list