Re: [rt-users] Fwd: How to list all enabled users in Perl script?
I'm planning to look at it later tonight or tomorrow. Thanks, Ruslan. Guys, please send version of DBIx::SearchBuilder, just in case it's not the latest. I'm running 1.63.
Re: [rt-users] Fwd: How to list all enabled users in Perl script?
Hi guys, Can you test the following patch? On Thu, Sep 5, 2013 at 12:21 PM, Nathan Cutler presnyprek...@gmail.comwrote: I'm planning to look at it later tonight or tomorrow. Thanks, Ruslan. Guys, please send version of DBIx::SearchBuilder, just in case it's not the latest. I'm running 1.63. -- Best regards, Ruslan. MergeUsers-dont-skip-records-in-collection.patch Description: Binary data
Re: [rt-users] Fwd: How to list all enabled users in Perl script?
Hello Ruslan, Can you test the following patch? This seems to fix the problem with Nathan's script aswell as mine where my user didn't show up in modify ticket. Thank you for your help! Cheers, Thomas
[rt-users] direction about extensions
Hello All I would like some direction as to which extensions I should add to RT version 4.13 for custom report writing. Thanks for the help. Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 * 262-783-6261 ext. 2296 bba...@copesan.commailto:cstep...@copesan.com www.copesan.comhttp://www.copesan.com/ Servicing North America with Local Care
Re: [rt-users] Custom Field as a column in search results?
On Wed, Sep 04, 2013 at 01:58:55PM +, Matt Brister wrote: I have my RT instance set up to have a Change Management queue with the hidden _Approvals method (works awesome by the way). Tickets in this queue have a Custom Field set for an Impact to user level. I would like to be able to see this CF value as a column in the search results of the [_1] newest unowned tickets. Is this possible without major modifications? As a superuser - Click on Edit, click on Edit this Saved Search, click on Advanced, add __CustomField.{Impact to user}__ to the search, update the search. If you were building a Queue specific search, you'd be able to do it from the normal Format builder at the bottom of the Query builder. -kevin pgpyQQsw_BSob.pgp Description: PGP signature
[rt-users] CLI question
I'm trying to use the 'rt' command line script. It's working, except for an annoying error message: $ rt list status='new' Query:status='new' Ticket Owner QueueAge Told Status Requestor Subject Unknown date format in parsedate: '2011-09-30 13:44' This Unknown date format error is written once for each line of output. Reading the code, I can see that RT is expecting the date format to include the seconds, yet in my case the seconds are missing. I can patch the code to add :00 on the end, but I'm curious to hear if others can reproduce this, or any ideas for a proper fix. Thanks! Nathan
Re: [rt-users] Custom Field as a column in search results?
Thanks Kevin, Worked like a charm! -MB -Original Message- From: Kevin Falcone falc...@bestpractical.commailto:kevin%20falcone%20%3cfalc...@bestpractical.com%3e Reply-to: rt-users@lists.bestpractical.com To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] Custom Field as a column in search results? Date: Thu, 5 Sep 2013 10:16:06 -0400 On Wed, Sep 04, 2013 at 01:58:55PM +, Matt Brister wrote: I have my RT instance set up to have a Change Management queue with the hidden _Approvals method (works awesome by the way). Tickets in this queue have a Custom Field set for an Impact to user level. I would like to be able to see this CF value as a column in the search results of the [_1] newest unowned tickets. Is this possible without major modifications? As a superuser - Click on Edit, click on Edit this Saved Search, click on Advanced, add __CustomField.{Impact to user}__ to the search, update the search. If you were building a Queue specific search, you'd be able to do it from the normal Format builder at the bottom of the Query builder. -kevin
Re: [rt-users] Fwd: How to list all enabled users in Perl script?
Can you test the following patch? I've applied the patch on both our testing and production instances. It seems to work! Will keep an eye on it to see if there are any undesired consequences. Thanks alot! Nathan
[rt-users] Search
Hello All Is it possible to build a custom search that queries a foreign table? A table that RT does not know about natively but exists in the same Mysql instance. If so hopefully I can be led in the direction as to how. Thanks in advance Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 * 262-783-6261 ext. 2296 bba...@copesan.commailto:cstep...@copesan.com www.copesan.comhttp://www.copesan.com/ Servicing North America with Local Care
Re: [rt-users] Search
Bummer I really needs this in the UI. Let’s try asking the question a different way. I have Custom fields on a ticket Client, Location, City, St. I would like a search that counts the tickets and groups by the above custom fields in one report. I can do them by one custom field at a time but I want them all in one report. Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.commailto:cstep...@copesan.com www.copesan.comhttp://www.copesan.com/ Servicing North America with Local Care From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, September 05, 2013 1:52 PM To: Bryon Baker Cc: RT Users (rt-users@lists.bestpractical.com) Subject: Re: [rt-users] Search On Thu, Sep 5, 2013 at 10:10 PM, Bryon Baker bba...@copesan.commailto:bba...@copesan.com wrote: Hello All Is it possible to build a custom search that queries a foreign table? A table that RT does not know about natively but exists in the same Mysql instance. If so hopefully I can be led in the direction as to how. It's possible with API, but not in the UI. See how RT calls `my $alias = $tickets-Join()` and then -Limit(...) using that alias. Thanks in advance Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.commailto:cstep...@copesan.com www.copesan.comhttp://www.copesan.com/ Servicing North America with Local Care -- Best regards, Ruslan.
Re: [rt-users] Re-send a previously attached attachment?
Am 03.09.2013 23:04, schrieb Kevin Falcone: I have not worked with your extension yet, but as I recall the two largest complaints with the branch as-is were: Maybe you or one of the other developers have time to have a look on my extension. Display of attachments on the new replies (they aren't true attachments, and render in a funny way and were otherwise not as obvious as needed). Fixed if we better fake-up the attachment record. I personally like the solution from Thomas in https://github.com/bestpractical/rt/commit/ea61a55 which is integrated with some small changes in my extension. Picking attachments from multiple transactions, especially on long attachment heavy tickets. This is a desirable feature, but just providing a list of all attachments is... unusable. We've played with a few other UX ideas also. If it is here an problem, isn't it also a problem with the attachments widget on Ticket/Display.html? My current idea is to place the widget with the attachments after the message widget and before the submit button. The widget will be by default rolled up, as the 'Scrips and Recipients' widget if you have set SimplifiedRecipients to true in RT_SiteConfig.pm. Sadly the necessary callback is missing but I just send an pull request: https://github.com/bestpractical/rt/pull/65 There's a longer internal writeup of problems with the branch, but it has some customer-specific things in it. I do hope we can find a solution for 4.4 but at this point we've missed the 4.2 window. After the 4.2 release may you have time to give some feedback on my extension so I can send a pull request to integrate this one in 4.4. As the recent blog posts may make clear, we're getting closer and closer to 4.2.0rc1. Thanks for the note. I missed this new posts (mainly because of my vacation). But on an dev box I have the master branch installed to take a look on RT 4.2 and I'm looking forward to the new release. Great work. Thanks! Chris
[rt-users] [rt-announce] RT 4.2.0rc1 released
We're extremely excited to announce the availability of RT 4.2.0rc1 - the first release candidate for the next major version of RT. We would be thrilled to hear your experiences installing or upgrading to this release; the more feedback we get, the sooner the official release of RT 4.2.0 can occur. Please be sure to review the upgrading documentation available in docs/UPGRADING-4.2, as there are a number of backward-incompatible changes that come along with the new version number. Upgrading documentation is also available here: http://www.bestpractical.com/docs/rt/4.2.0/UPGRADING-4.2.html http://download.bestpractical.com/pub/rt/devel/rt-4.2.0rc1.tar.gz http://download.bestpractical.com/pub/rt/devel/rt-4.2.0rc1.tar.gz.asc 3e82778fa3f820dd87c8c60e174aec5ce0fc643f rt-4.2.0rc1.tar.gz 4a8aac0a0d65fe9db94d89de0d56dd44ee4cbc1d rt-4.2.0rc1.tar.gz.asc A partial list of the new features in RT 4.2.0 is included below. Many of the new features will also be described and demoed in a series of blog posts on http://blog.bestpractical.com/ in the coming weeks. - Alex Vandiver, for Best Practical * Much improved reporting via search result charting - Multiple group by and statistic calculations in a table - Time statistics such as average, minimum, and maximum durations between Created and Resolved, Created and Started, Started and Resolved, and more. - More robust layout of charts * Increased performance for searches and ticket pages - Faster searches on all databases (especially Pg) - Ticket pages load quicker - Menus load before the rest of the page is loaded - History is loaded asynchronously - Faster serving of static assets * Scrips per queue - Apply scrips globally or ad-hoc to individual queues, a la custom fields - Less duplication of scrips and/or need for empty templates * Custom field groupings - Display CFs in configurable groupings (boxes) on the ticket display/edit pages - Includes arbitrary grouping names as well as standard ticket groupings (Basics, Dates, People, Links, etc.) * User summary pages - Display information about users such as tickets, history, groups, etc. - An extended More about requestors page for any user - Easy to get to via links and user search * HTML templates enabled by default for new installs, available for upgrades too * History improvements - Rich text/HTML messages are preferred for display by default - Images are inlined with text in ticket history display instead of presented at bottom - Clickable users, tickets, articles, and other items * Many interface improvements, such as: - Per-user preferences for the dashboards which appear in the Home menu - Floating page menu for quicker access to ticket actions, subpages, etc. - Autocomplete for ticket links, including when merging - Autocomplete available to self service users - Improved CF and links display in search results - Sticky simple search for quick search refinements - Attachments on reply can no longer be mixed up when replying to multiple tickets at once - ReassignTicket right to assign tickets without stealing first; useful for managers * S/MIME support integrated with GnuPG support - Decrypt and verify incoming GPG and SMIME messages - Send all outgoing messages as either GPG or SMIME * Migration tools - Migrate from one database type to another (MySQL, Pg, Oracle) - Merge multiple RT instances together * Thousands of bug fixes; nearly 2000 commits totalling more than 250,000 lines of code changed. ___ rt-announce mailing list rt-annou...@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce
Re: [rt-users] Search
On Thu, Sep 05, 2013 at 07:04:50PM +, Bryon Baker wrote: Bummer I really needs this in the UI. Let's try asking the question a different way. I have Custom fields on a ticket Client, Location, City, St. I would like a search that counts the tickets and groups by the above custom fields in one report. I can do them by one custom field at a time but I want them all in one report. Test RT-4.2.0rc1 released today, you can group by multiple custom fields at the same time. Please don't upgrade your production instance, but testing in a VM with a copy of your data would be great. -kevin pgpsFx0MPPXUm.pgp Description: PGP signature
Re: [rt-users] Search
On Thu, Sep 5, 2013 at 10:10 PM, Bryon Baker bba...@copesan.com wrote: Hello All ** ** Is it possible to build a custom search that queries a foreign table? ** ** A table that RT does not know about natively but exists in the same Mysql instance. ** ** If so hopefully I can be led in the direction as to how. It's possible with API, but not in the UI. See how RT calls `my $alias = $tickets-Join()` and then -Limit(...) using that alias. ** ** Thanks in advance ** ** Bryon Baker Network Operations Manager *Copesan** - Specialists in Pest Solutions* 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com cstep...@copesan.com www.copesan.com *Servicing North America with Local Care* ** ** -- Best regards, Ruslan.