Custom Search

Hi guys,

I am stuck now… Please Help…

I need to be able to search for tickets created between 16h00 on a
Friday afternoon and 17h00 on a Monday Morning.

How would I achieve this?

bashir jahed
nha | enhance

5 protea road | claremont | 7708
po box 24 | newlands | 7725

telephone +27 (21) 657-2574

mobile +27 (83) 414-0453

facsimile +27 (21) 657-2575

e-mail | messenger bashir.jahed@nha.co.za
mailto:bashir.jahed@nha.co.za

this message is subject to the disclaimer at
www.nha.co.za/disclaimer.asp http://www.nha.co.za/disclaimer.asp or
disclaimer@nha.co.za
mailto:disclaimer@nha.co.za?subject=request%20disclaimer

Bashir,

If I was looking for tickets created between 1600 on Friday, January 16th
2009 and 1700 Monday, January 19th, 2009, I would do the following:

In Query Builder use the “Created” field with “After” and the string:

Fri Jan 16 16:00:00 2009

And click “Add” to "Add these items to your search.

Then with the “AND” operator selected, use “Created” with “Before” and the
string:

Mon Jan 19 17:00:00 2009

I’m sure the proper formatting of “date/time” fields is in the
documentation somewhere, but I got it from the formatting in the “Dates”
section of ticket metadata. You can just copy and paste the string from
there and modify as necessary.

This formatting works for setting reminders as well.

Patrick-----Original Message-----
From: “Bashir Jahed” bashir.jahed@nha.co.za
To: rt-users@lists.bestpractical.com
Date: Wed, 28 Jan 2009 15:47:58 +0200
Subject: [rt-users] Custom Search

Hi guys,

I am stuck now… Please Help…

I need to be able to search for tickets created between 16h00 on a
Friday afternoon and 17h00 on a Monday Morning.

How would I achieve this?


bashir jahed
nha | enhance

5 protea road | claremont | 7708
po box 24 | newlands | 7725

telephone +27 (21) 657-2574

mobile +27 (83) 414-0453

facsimile +27 (21) 657-2575

e-mail | messenger bashir.jahed@nha.co.za
mailto:bashir.jahed@nha.co.za


this message is subject to the disclaimer at
www.nha.co.za/disclaimer.asp http://www.nha.co.za/disclaimer.asp or
disclaimer@nha.co.za
mailto:disclaimer@nha.co.za?subject=request%20disclaimer

Hi Everone,

I want to do a search based on the following:

Tickets resolved by userA and userB and userC where tickets status is
resolved and ticket was created after 2009-06-01

I am able to search for one user at a time, if I do userA and UserB it
searches tickets that are owned by userA and UserB

Can someone help please?

Hello Bahsir,

(Owner = ‘userB’ OR Owner = ‘userA’) AND (Status = 'Resolved)

Pop that into your advanced tab, hit apply, and you are good to go.

Thanks,
Bill G.On Fri, Jul 3, 2009 at 3:42 AM, Bashir Jahed bashir.jahed@nha.co.za wrote:

Hi Everone,

I want to do a search based on the following:

Tickets resolved by userA and userB and userC where tickets status is
resolved and ticket was created after 2009-06-01

I am able to search for one user at a time, if I do userA and UserB it
searches tickets that are owned by userA and UserB

Can someone help please?


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

Bill Graboyes
On Assignment At:
Toyota Motor Sales, USA, Inc.
Consumer Portal Delivery
Office: (310) 468-6754
Cell: (714) 515-8312