[rt-users] Signature per queue for replies only

2014-06-23 Thread opolke
Hi There, we have set up a script per queue for signatures. Problem is with “on correspondence”: when a requestor sends an email he gets the message he just has sent plus signature-template back per email. So we need a script that just sends out the signature-template when one of us replies to a

[rt-users] RT Shredder - More Questions

2014-06-23 Thread Lists
OK, so I am making a little more progress. I am running the rt-shredder script from /opt/rt3/sbin against my rt3 database. That seems to work a little better! I have tickets in my rt3 database that were created as far back as 2006-11-29. My goal is to keep the last three years of tickets

Re: [rt-users] non-admin user editing custom field values

2014-06-23 Thread Milt Epstein
OK, I see. That permission, AdminCustomFieldValues, I see in two places under Configuration: Configuration, Custom Field, the particular custom field, Group Rights Configuration, Global, Group Rights I assume the difference between these is kind of like the other case, the first is specific to

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-23 Thread Alex Vandiver
On 06/20/2014 07:16 PM, Lists wrote: When I run this against the database I am trying to upgrade, I get: mysql select count(*) from Attributes; +--+ | count(*) | +--+ | 1831962 | +--+ 1 row in set (2.50 sec) mysql select count(*) from Attributes where Name =

Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

2014-06-23 Thread Lists
Thanks for the info Alex, I appreciate it and will give it a try. Dave On 6/23/2014 11:29 AM, Alex Vandiver wrote: On 06/20/2014 07:16 PM, Lists wrote: When I run this against the database I am trying to upgrade, I get: mysql select count(*) from Attributes; +--+ | count(*) |

[rt-users] Customizing newest unowned tickets search with user-specific data?

2014-06-23 Thread Milt Epstein
Greetings. I'm trying to customize the 10 newest uowned tickets search (the one that appears on the main page by default, I believe). I get to the page to edit the predefined Search - Unowned Tickets search, and it shows the logic for the search: Owner = 'Nobody' AND ( Status = 'new' OR