[rt-users] RT Query - Ticket SQL
Ruslan Zakirov
ruz at bestpractical.com
Mon Mar 31 19:30:35 EDT 2008
Patches are welcome.
On Tue, Apr 1, 2008 at 3:11 AM, Kenneth Crocker <KFCrocker at lbl.gov> wrote:
> 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
> >>
> >
> >
> >
>
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list