TicketSQL question when searching on Requestor.Name. I have reviewed the
Wiki and the RT book but been unable to construct a TicketSQL statement to
return my requirements.
The QueryBuilder shows the same result set. Is it something to do with
joins?
OS: RHES4, RT: 3.4.5
Setup:
ticket/100 contains
Requestors: ReqA, ReqB
ticket/101 contains
Requestors: ReqA
Command:
rt list -i “Requestor.Name != ‘ReqB’”
->ticket/100
->ticket/101
What is the TicketSQL construct that would return ticket/101 only ?
Using LIKE, NOT LIKE I’m still unable to return the single ticket.
I’m using the Query Builder in RT and would like to create a report for
tickets created in the last 7 days. I’m able to get the report to look the
way I want, but just am unable to generate this for the last 7 days. I can
use a specific date, but I would like to easily be able to run this search
in the future without having to change the date.
Any help or suggestions is appreciated.
Thanks,
Jared
Get real-time traffic reports with Windows Live Local Search
RT accepts some “natural language” date queries, such as “7 days ago” or
“yesterday”.
Here’s an example Saved Search we use:
“Status = ‘open’ AND LastUpdated < ‘7 days ago’ AND ( Queue =
‘projects’ OR Queue = ‘support’ )”
-jdOn Tue, 12 Sep 2006, Jared Hanks wrote:
Hello,
I’m using the Query Builder in RT and would like to create a report for
tickets created in the last 7 days. I’m able to get the report to look the
way I want, but just am unable to generate this for the last 7 days. I can
use a specific date, but I would like to easily be able to run this search in
the future without having to change the date.
I’m using the Query Builder in RT and would like to create a report
for tickets created in the last 7 days. I’m able to get the report
to look the way I want, but just am unable to generate this for the
last 7 days. I can use a specific date, but I would like to easily
be able to run this search in the future without having to change the date.
Any help or suggestions is appreciated.
Thanks,
Jared
Jared,
You can do a query for Created After ‘-7 days’ on the QB screen (no
quotes needed). Or (Created > ‘-7 days’ ) on the Advanced screen
(quotes needed). (This works up to 3.4, I can’t say if it’s the same on 3.6.x).
RT accepts some “natural language” date queries, such as “7 days ago” or
“yesterday”.
Here’s an example Saved Search we use:
“Status = ‘open’ AND LastUpdated < ‘7 days ago’ AND ( Queue =
‘projects’ OR Queue = ‘support’ )”
-jd
Hello,
I’m using the Query Builder in RT and would like to create a report for
tickets created in the last 7 days. I’m able to get the report to look
the way I want, but just am unable to generate this for the last 7 days.
I can use a specific date, but I would like to easily be able to run this
search in the future without having to change the date.