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
[rt-users] Custom Search
Hi Everone, I want to do a search based on the following: Tickets resolved by userA and userB and userC where tickets status is resolved and ticket was created after 2009-06-01 I am able to search for one user at a time, if I do userA and UserB it searches tickets that are owned by userA and UserB Can someone help please? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Custom Search
Hello Bahsir, (Owner = 'userB' OR Owner = 'userA') AND (Status = 'Resolved) Pop that into your advanced tab, hit apply, and you are good to go. Thanks, Bill G. On Fri, Jul 3, 2009 at 3:42 AM, Bashir Jahed bashir.ja...@nha.co.za wrote: Hi Everone, I want to do a search based on the following: Tickets resolved by userA and userB and userC where tickets status is resolved and ticket was created after 2009-06-01 I am able to search for one user at a time, if I do userA and UserB it searches tickets that are owned by userA and UserB Can someone help please? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Bill Graboyes On Assignment At: Toyota Motor Sales, USA, Inc. Consumer Portal Delivery Office: (310) 468-6754 Cell: (714) 515-8312 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom Search
Hi guys, I am stuck now Please Help... I need to be able to search for tickets created between 16h00 on a Friday afternoon and 17h00 on a Monday Morning. How would I achieve this? bashir jahed nha | enhance 5 protea road | claremont | 7708 po box 24 | newlands | 7725 telephone +27 (21) 657-2574 mobile +27 (83) 414-0453 facsimile +27 (21) 657-2575 e-mail | messenger bashir.ja...@nha.co.za mailto:bashir.ja...@nha.co.za this message is subject to the disclaimer at www.nha.co.za/disclaimer.asp http://www.nha.co.za/disclaimer.asp or disclai...@nha.co.za mailto:disclai...@nha.co.za?subject=request%20disclaimer ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Custom Search Possibilities
Sweet. Thanks, works like a charm. Keep up with me and what I'm up to: http://theillien.blogspot.com Todd Chapman wrote: Try 2 days ago On 12/27/07, Mathew Snyder [EMAIL PROTECTED] wrote: Yes, that manages to return every ticket in teh database Keep up with me and what I'm up to: http://theillien.blogspot.com Schincke, Keith D. (JSC-IT)[MEI] wrote: Have you tried the below? LastUpdated '-2 days' Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder Sent: Thursday, December 27, 2007 4:20 PM To: [EMAIL PROTECTED] Subject: [rt-users] Custom Search Possibilities A colleague asked me if it is possible to create a search for tickets last updated within the past 48 hours. He can search for 'yesterday' as well as 'today'. Is it possible to create a search that can do '48 hours ago'? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom Search Possibilities
A colleague asked me if it is possible to create a search for tickets last updated within the past 48 hours. He can search for 'yesterday' as well as 'today'. Is it possible to create a search that can do '48 hours ago'? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Custom Search Possibilities
Yes, that manages to return every ticket in teh database Keep up with me and what I'm up to: http://theillien.blogspot.com Schincke, Keith D. (JSC-IT)[MEI] wrote: Have you tried the below? LastUpdated '-2 days' Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder Sent: Thursday, December 27, 2007 4:20 PM To: [EMAIL PROTECTED] Subject: [rt-users] Custom Search Possibilities A colleague asked me if it is possible to create a search for tickets last updated within the past 48 hours. He can search for 'yesterday' as well as 'today'. Is it possible to create a search that can do '48 hours ago'? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] Custom Search Possibilities
Have you tried the below? LastUpdated '-2 days' Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder Sent: Thursday, December 27, 2007 4:20 PM To: [EMAIL PROTECTED] Subject: [rt-users] Custom Search Possibilities A colleague asked me if it is possible to create a search for tickets last updated within the past 48 hours. He can search for 'yesterday' as well as 'today'. Is it possible to create a search that can do '48 hours ago'? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Custom Search Possibilities
Try 2 days ago On 12/27/07, Mathew Snyder [EMAIL PROTECTED] wrote: Yes, that manages to return every ticket in teh database Keep up with me and what I'm up to: http://theillien.blogspot.com Schincke, Keith D. (JSC-IT)[MEI] wrote: Have you tried the below? LastUpdated '-2 days' Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder Sent: Thursday, December 27, 2007 4:20 PM To: [EMAIL PROTECTED] Subject: [rt-users] Custom Search Possibilities A colleague asked me if it is possible to create a search for tickets last updated within the past 48 hours. He can search for 'yesterday' as well as 'today'. Is it possible to create a search that can do '48 hours ago'? -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com