Re: [rt-users] relative date search
You can enter 14 days ago into the Created box, or Created 14 days ago into the Advanced screen of the search builder. On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard bernhard.eierschm...@scheppach.com wrote: Hello, is it possible to make date-searches in RT with relative date? For example search all open tickets where creation-date is older than 14 days. best regards Bernhard
[rt-users] relative date search
Hello, is it possible to make date-searches in RT with relative date? For example search all open tickets where creation-date is older than 14 days. best regards Bernhard
Re: [rt-users] relative date search
Here's all of the acceptable syntax: https://metacpan.org/pod/Time::ParseDate#Relative-date-formats On Fri, 6 Mar 2015 5:48 pm Alex Peters a...@peters.net wrote: You can enter 14 days ago into the Created box, or Created 14 days ago into the Advanced screen of the search builder. On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard bernhard.eierschm...@scheppach.com wrote: Hello, is it possible to make date-searches in RT with relative date? For example search all open tickets where creation-date is older than 14 days. best regards Bernhard
[rt-users] Relative Date Search Help - current week(end)?
Currently on RT 4.0.12 Doing a custom search and could use some help. We are using a custom search field (date/time) and trying to do a search for anything for the current weekend. Tried using logic such as 'friday after last' and other things, but no luck. Trying to set up some dashboards so when viewed, it'll show tickets for the current weekend. Best I got so far was 'last sunday' AND 'next monday'. That at least shows the current week, but I need ONLY the weekend. Thanks in advance! -- View this message in context: http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Relative Date Search Help - current week(end)?
Why not just next Saturday or next Sunday On 18 Feb 2014 15:39, drhamilton11 drhamilto...@hotmail.com wrote: Currently on RT 4.0.12 Doing a custom search and could use some help. We are using a custom search field (date/time) and trying to do a search for anything for the current weekend. Tried using logic such as 'friday after last' and other things, but no luck. Trying to set up some dashboards so when viewed, it'll show tickets for the current weekend. Best I got so far was 'last sunday' AND 'next monday'. That at least shows the current week, but I need ONLY the weekend. Thanks in advance! -- View this message in context: http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Relative Date Search Help - current week(end)?
That will not work because viewing the search on Friday will show the following weekend's tickets, not the current weekend. Anyone else have any suggestions? Thanks! -- View this message in context: http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688p56698.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Relative Date Search Help - current week(end)?
On Tue, Feb 18, 2014 at 07:39:41AM -0800, drhamilton11 wrote: Doing a custom search and could use some help. We are using a custom search field (date/time) and trying to do a search for anything for the current weekend. Tried using logic such as 'friday after last' and other things, but no luck. Trying to set up some dashboards so when viewed, it'll show tickets for the current weekend. Best I got so far was 'last sunday' AND 'next monday'. That at least shows the current week, but I need ONLY the weekend. We use this module https://metacpan.org/pod/Time::ParseDate#DATE-FORMATS-RECOGNIZED That's what is supports. You may want to play with http://bestpractical.com/docs/rt/latest/RT_Config.html#AmbiguousDayInPast-AmbiguousDayInFuture -kevin pgpEHIoggvs5m.pgp Description: PGP signature -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Relative Date Search Help - current week(end)?
Still looking for help on this. I can't seem to get the logic. Again, if I want to set up a dashboard showing what ticket are due THIS COMING Fri/Sat/Sun - is that possible? It can flip on Sunday, that would be fine. The problem with searches like after next thursday and before next monday, is that on that thursday, it would display the week ahead of the current. There's gotta be some backward logic that'll make this work. Thanks! -- View this message in context: http://requesttracker.8502.n7.nabble.com/Relative-Date-Search-Help-current-week-end-tp56688p56710.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training