[rt-users] search for 'this week'?

Jeffrey Pilant jeffrey.pilant at bayer.com
Fri Apr 15 13:19:39 EDT 2016


Stephen Dowdy wrote:
> I created saved searches:
>
>    "This Week's Tickets"   =   Created > 'Last Sunday'
>    "Last Week's Tickets"   =   Created > 'Sunday Before Last' AND Created <
> 'Last Sunday'
>    "Today's Tickets"       =   Created > 'Midnight'
>    "Yesterday's Tickets"   =   Created > 'midnight 1 days ago' AND Created
> < 'midnight'
>
> adding from there, you should be able to modify for Resolved, Owned by Me,
> etc...

Hope you don't put in tickets on Sunday or at midnight.
[Likely safe bet, but just in case...]

Query should be something like:
   "This Week's Tickets"   =   Created >  'Last Sunday'
   "Last Week's Tickets"   =   Created >  'Sunday Before Last'
                           AND Created <= 'Last Sunday'
   "Today's Tickets"       =   Created >  'Midnight'
   "Yesterday's Tickets"   =   Created >  'midnight 1 days ago'
                           AND Created <= 'midnight'

/jeff

________________________________________________________________________
The information contained in this e-mail is for the exclusive use of the 
intended recipient(s) and may be confidential, proprietary, and/or 
legally privileged.  Inadvertent disclosure of this message does not 
constitute a waiver of any privilege.  If you receive this message in 
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message.  Please also delete this e-mail 
and all copies and notify the sender.  Thank you. 

For alternate languages please go to http://bayerdisclaimer.bayerweb.com
________________________________________________________________________



More information about the rt-users mailing list