[rt-users] RT Query - Ticket SQL

[Kenneth Crocker]

Ruslan,


	Any chance this feature can be added to the Search Builder?


Kenn
LBNL

On 3/27/2008 2:51 PM, Ruslan Zakirov wrote:
> You are the first one person who requested such functionality in UI.
> 
> On Fri, Mar 28, 2008 at 12:39 AM, Kenneth Crocker <KFCrocker at lbl.gov> wrote:
>> 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
>>  >
>>  >
>>  >
>>
>>  _______________________________________________
>>  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
>>
> 
> 
>