Patches are welcome. On Tue, Apr 1, 2008 at 3:11 AM, Kenneth Crocker <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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: [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 > >> > > > > > > > >
-- Best regards, Ruslan. _______________________________________________ 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
