Re: [rt-users] Custom search based on full months
I need this functionality too, and I'm planing to modify TimeParse in order to make it understand something like beginning of last month or end of last week, since as Ruslan suggested I think this would be the cleanest approach. But reading this thread, looks like I'm not the only one with this problem, so I'm forced to ask. Does anyone has a patch for TimeParse that will allow this functionality ? -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
On Tue, 2011-11-08 at 10:20 -0600, k...@rice.edu wrote: It still looks like the best option would be to patch the Time::ParseDate code to do what you want it to do. Even if you could inject MySQL-isms into the search, it makes the result only useful for MySQL backends. I know that I have wanted to do something similar in the past, i.e. syntax like: [...] I have not looked at what that would entail and still maintain the existing functionality. Have you tried to contact the Time::ParseDate author? Just chiming in here... I submitted a patch to Time::ParseDate for something similar (day of week before last) a few years ago. ISTR it's not a difficult module to work with. Good luck, Ole -- Ole Craig Operations www.symplified.com RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
ok, so it doens't look possible based on the ticket search. Can I manually edit the Saved Search to do what I need it to do? I see that the Saved Search is encoded some how, is this just a basic mysql query or is it based on the fake query saved by the search page? Will this area take standard mysql functions? If so is it possible for me to decode and re-encode it? Thanks in advance. -- Scott Benson System Administrator | A1 Networks Voice: 707-703-1043 For support issues please email supp...@a-1networks.com or call 707-703-1050 On 11/7/11 11:22 AM, Kevin Falcone wrote: On Mon, Nov 07, 2011 at 11:08:48AM -0800, Scott Benson wrote: Thank you for your response Kevin. I am not seeing anything that looks like it might help me out. What I am looking for is a custom search that is based on the current month by name/number. I don't care about the month as -30 day. I just want something available to have a select that shows this month and last month so customers can see their queue and what was worked on during a certain billing cycle. Is this even possible? Unfortunately, as I mentioned in the previous email, it's dependent on the featureset of ParseDate, so you'd need to know if they support it. We support a number of grouping by month things, but that's for charting not for searching. -kevin On 11/3/11 10:12 AM, Kevin Falcone wrote: On Thu, Nov 03, 2011 at 09:20:14AM -0700, Scott Benson wrote: I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. Those are all parsed by Time::ParseDate, so anything it can handle we can use: https://metacpan.org/module/Time::ParseDate RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
On Tue, Nov 08, 2011 at 08:10:19AM -0800, Scott Benson wrote: ok, so it doens't look possible based on the ticket search. Can I manually edit the Saved Search to do what I need it to do? I see that the Saved Search is encoded some how, is this just a basic mysql query or is it based on the fake query saved by the search page? Will this area take standard mysql functions? If so is it possible for me to decode and re-encode it? Thanks in advance. -- Scott Benson System Administrator | A1 Networks Voice: 707-703-1043 It still looks like the best option would be to patch the Time::ParseDate code to do what you want it to do. Even if you could inject MySQL-isms into the search, it makes the result only useful for MySQL backends. I know that I have wanted to do something similar in the past, i.e. syntax like: last month = the beginning of the previous calendar month to the end of the month last week = the beginning of the previous calendar week to the end of that week this month = the beginning of the current calendar month to the end of the month this week = the beginning of the current calendar week to the end of the week I have not looked at what that would entail and still maintain the existing functionality. Have you tried to contact the Time::ParseDate author? Regards, Ken RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
Thank you for your response Kevin. I am not seeing anything that looks like it might help me out. What I am looking for is a custom search that is based on the current month by name/number. I don't care about the month as -30 day. I just want something available to have a select that shows this month and last month so customers can see their queue and what was worked on during a certain billing cycle. Is this even possible? -- Scott Benson System Administrator | A1 Networks Voice: 707-703-1043 For support issues please email supp...@a-1networks.com or call 707-703-1050 On 11/3/11 10:12 AM, Kevin Falcone wrote: On Thu, Nov 03, 2011 at 09:20:14AM -0700, Scott Benson wrote: I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. Those are all parsed by Time::ParseDate, so anything it can handle we can use: https://metacpan.org/module/Time::ParseDate -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
Patch module mentioned by Kevin. Regards, Ruslan. From phone. 07.11.2011 22:09 пользователь Scott Benson sben...@a-1networks.com написал: Thank you for your response Kevin. I am not seeing anything that looks like it might help me out. What I am looking for is a custom search that is based on the current month by name/number. I don't care about the month as -30 day. I just want something available to have a select that shows this month and last month so customers can see their queue and what was worked on during a certain billing cycle. Is this even possible? -- Scott Benson System Administrator | A1 Networks Voice: 707-703-1043 For support issues please email supp...@a-1networks.com or call 707-703-1050 On 11/3/11 10:12 AM, Kevin Falcone wrote: On Thu, Nov 03, 2011 at 09:20:14AM -0700, Scott Benson wrote: I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. Those are all parsed by Time::ParseDate, so anything it can handle we can use: https://metacpan.org/module/**Time::ParseDatehttps://metacpan.org/module/Time::ParseDate -kevin RT Training Sessions (http://bestpractical.com/**services/training.htmlhttp://bestpractical.com/services/training.html ) * Barcelona, Spain — November 28 29, 2011 RT Training Sessions (http://bestpractical.com/**services/training.htmlhttp://bestpractical.com/services/training.html ) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
On Mon, Nov 07, 2011 at 11:08:48AM -0800, Scott Benson wrote: Thank you for your response Kevin. I am not seeing anything that looks like it might help me out. What I am looking for is a custom search that is based on the current month by name/number. I don't care about the month as -30 day. I just want something available to have a select that shows this month and last month so customers can see their queue and what was worked on during a certain billing cycle. Is this even possible? Unfortunately, as I mentioned in the previous email, it's dependent on the featureset of ParseDate, so you'd need to know if they support it. We support a number of grouping by month things, but that's for charting not for searching. -kevin On 11/3/11 10:12 AM, Kevin Falcone wrote: On Thu, Nov 03, 2011 at 09:20:14AM -0700, Scott Benson wrote: I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. Those are all parsed by Time::ParseDate, so anything it can handle we can use: https://metacpan.org/module/Time::ParseDate pgpJ7UkJoRvua.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] Custom search based on full months
I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. -- Scott Benson RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
On Thu, Nov 03, 2011 at 09:20:14AM -0700, Scott Benson wrote: I am looking to use RT's ticket search feature to show tickets that were created this month, ie November 1st - November 30th. Also another search for last month. we don't want anything that is - 30 day or - 1 month. We're trying to setup a dashboard that shows customers what is being worked on this month, and what was worked on last month. btw this is in RT 3.8.8. Thanks in advance. Those are all parsed by Time::ParseDate, so anything it can handle we can use: https://metacpan.org/module/Time::ParseDate -kevin pgpVkxH9l9K1S.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
