[rt-users] Search Custom Field for Today's Date

[Eynat Nir Mishor]

Thanks Greg - you pointed me in the direction of a solution.

 

It seems that RT uses Time::ParseDate module whose documentation can be
found here: http://search.cpan.org/~muir/Time-modules/lib/Time/ParseDate.pm

It has a wide range of input it can parse.

The relative to current time include:

"now" (today)

"Yesterday"

"now - 7 days"

Etc.

 

Exactly what I needed - thanks!

Eynat

 

From: Greg Evans [mailto:gevans at hcc.net] 
Sent: Sunday, 03 February 2008 10:21 PM
To: Eynat Nir Mishor
Cc: Greg Evans
Subject: Re: [rt-users] Search Custom Field for Today's Date

 

I haven't tried this, but would something like:

 

AND 'CF.{Appt. Date} = 'now'

 

work maybe?

 

I know I am using now in a custom search and it seems to be working for what
I am doing with it and that is just showing all tickets generated that day.

 

My search is "Created = 'now' OR Updated = 'now'

 

Just checked it and since I am off for the weekend, and currently the only
person creating tickets, it shows 0 results. DOn't know if that would work
for you or not, but it seems to work for me when I am at work.

 

 

 

Regards,

 

Greg Evans

 

On Feb 3, 2008, at 5:24 AM, Eynat Nir Mishor wrote:





Hi Darren, list,

 

6 months later. have you found a solution to this problem?

I too would like to have a saved search that filters by current date (or
current week, or some other date range relative to today).

It seems there's no such code in pure RT.

Has anyone developed it for his own RT?

 

Thanks in advance,

 

Eynat

 

 

From: Darren Ellis [darren at mepad.net]
Sent: Aug 11, 2007, 4:54 AM
To: rt-users at lists.bestpractical.com
Subject: Search Custom Field for Today's Date

 

Hi All, 

I am using RT 3.6.4 on CentOS 5.0. Everything stock seems to be 
working fine. 

I've defined a few custom fields, one of which I am using as an 
appointment date field. I would like to create a saved search called 
"Today's Assignments" that automatically searches the date field for 
today's date and returns matches. 

Googling led me to articles that implied that you could use "TODAY" 
or "today" as a search criterion. As yet I am unable to successfully 
make this search work. 

I have tried the following date formats in the field: 

YYYYMMDD (20070811) 
MM/DD/YYYY (8/11/2007) 

My search criterion line is: 
AND 'CF.{Appt. Date} = 'today' 


I have also tried: 
AND 'CF.{Appt. Date} = 'TODAY' 

I looked through my copy of RT Essentials and didn't find the 
information I needed there either. 

Can anyone help? 

Thanks. 

Darren

 

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080204/4acb5093/attachment.htm>