[rt-users] RT Query

[Kenneth Crocker]

To all & Jesse,


	I have wondered if it would be RT Query could be enhanced to allow two 
things:

	1) The ability to search for Queues with the "LIKE" command.
  	Reason; I have several groups that have more than 15 queues (1 has 52 
Queues) under their management. In order for them to write a query to 
look at ALL the queues they are responsible for, they have to include 
EACH QUEUE by name in the SQL, rather than Queue like "BTS-" and get all 
  Queues that start with "BTS-". That would save a bit of code and time.

	2) Add the ability to get history records from RT. We allow different 
types of date, why not allow transactions records with type = comment" 
or "correspond", etc.?
	Reason; my users want to get some queries that show the comments 
they've made on tickets.

	Right now, I am having to create some non-normalized views of the RT 
data so they can create these kind of queries OUTSIDE of RT. I'd prefer 
to keep them INSIDE RT.

	Is it possible to put these type of options in rt 3.8.3 or 3.8.4?


Kenn
LBNL