[rt-users] RT Query - Ticket SQL

[Kenneth Crocker]

Ruslan,


	What can I say? I'm just one of those guys who looks at things from a 
unique perspective ;-). Actually, the real need is based on the 
situation I mentioned, a manager with many, many queues to manage. I 
think it would be reasonable for a manager to want a query like that.
	On another query note, I went ahead and built a query searching for 15 
queues (queue = 'xx' OR queue = 'yy', etc) and when I went to the sort 
preferences and specified queue. The results were NOT alphabetical at 
all, it was by queue_id. Bummer. There was no option of selecting "Queue 
Name" either. When I ran the search anyway and then "left-clicked' the 
Queue heading (supposed to cause results to re-sort by that heading), it 
stretched out the subject column for 200 someodd spaces. Wierd also. 
Then I tried to create a Time Worked search pulling the same queues and 
tried to set the sort preference by owner and THAT also was not an 
option. It seems to me that if you offer the time elements of a ticket, 
why not offer the ability to sort the results by owner? Wouldn't that be 
a realistic need for a manager? Am I missing some parts for my search 
engine or what? It seems a bit "unfinished". Any help here would REALLY 
be helpful. Thanks.

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
>>
> 
> 
>