[rt-users] RT Query - Ticket SQL

[Kenneth Crocker]

Micah,

	I do not believe the '%' works in RT for Queue. Try it out. I get 
nothing. I guess if someone wants to see 15 or more queues that start 
with the same pre-fix in a search, they will have to add them one at a 
time, waiting for the screen to refresh each time and go from there. 
What an incredible waste of time.


Kenn
LBNL

On 3/27/2008 1:39 PM, Micah Gersten wrote:
> 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
>  
> 
>