TicketSQL, QueryBuilder search construction for returning ticket id's which don't have a specifc Requestor.Name

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.

Alex Strachan

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.

Any help or suggestions is appreciated.

Thanks,
Jared

Get real-time traffic reports with Windows Live Local Search

Jared-- (cc: rt-users)

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.

Any help or suggestions is appreciated.

Thanks,
Jared


Get real-time traffic reports with Windows Live Local Search
Bing Maps - Directions, trip planning, traffic cameras & more


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a
copy at http://rtbook.bestpractical.com

At Tuesday 9/12/2006 05:57 PM, 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.

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

Steve

That worked great.

Thanks,
Jared

From: “Jason A. Diegmueller” doogles@doogles.com
To: Jared Hanks jmhanks1373@hotmail.com
CC: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Query Builder, report for last 7 days
Date: Tue, 12 Sep 2006 23:57:50 -0400 (EDT)

Jared-- (cc: rt-users)

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.

Any help or suggestions is appreciated.

Thanks,
Jared


Get real-time traffic reports with Windows Live Local Search
Bing Maps - Directions, trip planning, traffic cameras & more


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a
copy at http://rtbook.bestpractical.com

Got something to buy, sell or swap? Try Windows Live Expo
ttp://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http://expo.live.com/