Re: [rt-users] Untouched Tickets

2011-01-07 Thread tanguy.lagroy
LastUpdated < 3 days ago
Works fine !

So simple

Le 7 janv. 2011 à 22:51, "Jason Ledford" 
mailto:jledf...@biltmore.com>> a écrit :

LastUpdated <


Re: [rt-users] Untouched Tickets

2011-01-07 Thread Jason Ledford
Funny how no matter how many times I have gone through the interface I didn’t 
see the LastUpdated field.  I like the use of “yesterday” and this is pretty 
much what I want.  Is there any other variable/function I could use besides 
yesterday so I could create and save this search and not have to enter a date.  
Like show me last updated 3 days ago:
LastUpdated < 'yesterday -3' AND (  Status = 'new' OR Status = 'open' )

Any way to make a saved search like that?

From: Paul D. O'Rorke [mailto:p...@paulororke.net]
Sent: Friday, January 07, 2011 12:26 PM
To: Jason Ledford
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Untouched Tickets

[file:///C:\Users\paul\AppData\Local\Temp\moz-screenshot-674.png][file:///C:\Users\paul\AppData\Local\Temp\moz-screenshot-675.png]Hi
 Jason,

I created a Dashboard from the following query made in the Query builder.   I 
call it "Not touched today"...
Queue = 'Support'
AND Status - 'open'
AND LastUpdated < 'yesterday'
AND 'CF.{Long Term}' != 'True'

The CF is a custom field I have for tickets that are long term and I want to 
exclude these from my results.

This might be a good place to start.

Regards


From: "Jason Ledford" 
To: rt-users@lists.bestpractical.com
Sent: Friday, 7 January, 2011 12:52:15 PM
Subject: [rt-users] Untouched Tickets


I am looking for a way to search for untouched tickets that are not new but 
untouched for a specified amount of time?  I found this 
http://www.gossamer-threads.com/lists/rt/users/42582?search_string=untouched;#42582
 but it looks more like taking action and also using rt-cron.  I am just 
looking to make a search.

Any help is appreciated.


--
Paul O'Rorke

p...@paulororke.net<http://mailto:p...@paulororke.net>
Home  .: +1 (250) 483 1456
Mobile.: +1 (250) 709 7740


Re: [rt-users] Untouched Tickets

2011-01-07 Thread Paul D. O'Rorke
Hi Jason, 

I created a Dashboard from the following query made in the Query builder. I 
call it "Not touched today"... 


Queue = 'Support' 
AND Status - 'open' 
AND LastUpdated < 'yesterday' 
AND 'CF .{Long Term}' != 'True' 

The CF is a custom field I have for tickets that are long term and I want to 
exclude these from my results. 

This might be a good place to start. 

Regards 



From: "Jason Ledford " < jledford @ biltmore .com> 
To: rt-us...@lists. bestpractical .com 
Sent: Friday, 7 January, 2011 12:52:15 PM 
Subject: [rt-users] Untouched Tickets 




I am looking for a way to search for untouched tickets that are not new but 
untouched for a specified amount of time? I found this 
http://www.gossamer-threads.com/lists/rt/users/42582?search_string=untouched;#42582
 but it looks more like taking action and also using rt-cron. I am just looking 
to make a search. 



Any help is appreciated. 



Jason Ledford 

Systems Analyst 

The Biltmore Company 

One North Pack Square 

Asheville , NC 28801 

(828) 225-6127 



-- 
Paul O'Rorke 

p...@paulororke.net 
Home .: +1 (250) 483 1456 
Mobile.: +1 (250) 709 7740 


[rt-users] Untouched Tickets

2011-01-07 Thread Jason Ledford
I am looking for a way to search for untouched tickets that are not new but 
untouched for a specified amount of time?  I found this 
http://www.gossamer-threads.com/lists/rt/users/42582?search_string=untouched;#42582
 but it looks more like taking action and also using rt-cron.  I am just 
looking to make a search.

Any help is appreciated.

Jason Ledford
Systems Analyst
The Biltmore Company
One North Pack Square
Asheville, NC 28801
(828) 225-6127