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
