[rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
Version : RT-4.0.19 Hey All, Running into a slight problem with a new queue I'm attempting to roll out a new queue that uses some pre-canned template responses using Articles from the integrated RTFM system in 4.0.19 now. I've changed the lifecycle to make the open - resolve a default

Re: [rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
that comment still exists in the 4.2 code? Any ideas on a workaround if this is indeed what I'm running into? Nicola From: Foggi, Nicola Sent: Saturday, August 02, 2014 7:45 PM To: rt-users@lists.bestpractical.com Subject: Custom Condition To Send Email on Resolve

Re: [rt-users] Custom Condition To Send Email on Resolve if No Article Sent as Part of Resolve

2014-08-02 Thread Foggi, Nicola
Thanks Alex, That code with some modification worked for me, I only want the scip to apply IF Status changed - resolved AND NOT if RefersTo link is added (I can ignore the correspondence I think safely as the significant event is the addlink to the article (that it's set already to send out

Re: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8

2010-08-18 Thread Foggi, Nicola
I had the same problem and ended up dropping the Groups2 index and performance went back to normal Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Alex Young Sent: Wed 8/18/2010 6:07 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Slow

Re: [rt-users] Approvals not working

2010-07-29 Thread Foggi, Nicola
' OR Status = 'stalled') Why don't any of the approvals with status=new show in the results screen? Any ideas what is going on here? Mike Michael James mja...@stonebridgebank.com 7/28/2010 4:57 PM It worked on 3.4.6, which is the version we were using before 3.8.8. Foggi, Nicola nfo...@depaul.edu

Re: [rt-users] Mysql queries slow

2010-07-21 Thread Foggi, Nicola
with no real mysql tweaking on RT 3.8.8 I get: mysql select count(id) from Attachments; +---+ | count(id) | +---+ | 41636 | +---+ 1 row in set (0.62 sec) while significantly less that yours, .62 seconds isn't too shabby... -Original Message- From:

Re: [rt-users] RT 3.8.8 - Can a superuser reset a users password?

2010-07-10 Thread Foggi, Nicola
. -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Kevin Falcone Sent: Sat 7/10/2010 3:17 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.8.8 - Can a superuser reset a users password? On Fri, Jul 09, 2010 at 09:22:58PM -0500, Foggi, Nicola wrote

Re: [rt-users] Slow Ticket History 3.8.8

2010-06-29 Thread Foggi, Nicola
I did just have a problem with 3.8.8 and one of the indexes (didn't have the problem on 3.8.6 or below). It turned out to be the index GROUPS2 on the Groups table... dropped the index, and performance was back to normal (pre 3.8.8) Nicola -Original Message- From:

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
= 'User') AND ((Groups_3.Domain = 'RT::Queue-Ro le' AND Groups_3.Instance = '3') OR (Groups_3.Domain = 'RT::System-Role')) AND (Groups_3.Type = 'AdminCc') ORDER BY main.Name ASC; Is there a reason it's looking at 3314678 rows for what returns the user listing? Nicola 2010/6/25 Foggi, Nicola nfo

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
. That query is what is performed when I display a ticket through the web interface. Any help is appreciated! Nicola -Original Message- From: ruslan.zaki...@gmail.com on behalf of Ruslan Zakirov Sent: Fri 6/25/2010 11:05 AM To: Foggi, Nicola Cc: rt-users@lists.bestpractical.com Subject

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
it goes wrong, but any ideas on where to start? My guess is something around the IncludeSystemRights logic somewhere in WhoHaveRight or WhoHaveRoleRight? Nicola -Original Message- From: ruslan.zaki...@gmail.com on behalf of Ruslan Zakirov Sent: Fri 6/25/2010 11:05 AM To: Foggi, Nicola

[rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-24 Thread Foggi, Nicola
hey everyone, after upgrading from 3.8.6 to 3.8.8 we're getting a slow query on this query: use rt3; SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId =

[rt-users] Ticket Status Change on Final Chained Approval

2010-03-23 Thread Foggi, Nicola
Hey Everyone, So we have implemented approvals under RT 3.8.6 basically to track and approval purchase requests. The request has to go through 2 levels of approvals, at which point i have it setup to email our purchasing department the information to complete the purchase. In researching

Re: [rt-users] Approval Queue Approved/Rejected Templates and Parent Request Correspondence

2010-03-03 Thread Foggi, Nicola
: [rt-users] Approval Queue Approved/Rejected Templates and Parent Request Correspondence On Tue, Mar 02, 2010 at 11:33:24PM -0600, Foggi, Nicola wrote: Hey Everyone, So we're utilizing approvals, and when an approver approvals or rejects a request, the owner of the parent request

[rt-users] Approval Queue Approved/Rejected Templates and Parent Request Correspondence

2010-03-02 Thread Foggi, Nicola
Hey Everyone, So we're utilizing approvals, and when an approver approvals or rejects a request, the owner of the parent request gets double notifications. The first is from the templates: Approval Passed All Approvals Passed Approval Rejected the 2nd email is the fact that it puts the

Re: [rt-users] Approval Queue Approved/Rejected Templates and ParentRequest Correspondence

2010-03-02 Thread Foggi, Nicola
I should of mentioned it's 3.8.6... -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Tue 3/2/2010 11:33 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Approval Queue Approved/Rejected Templates and ParentRequest

Re: [rt-users] ExternalAuth TLS to Active DirectoryLDAP_OPERATIONS_ERROR 1 on Bind

2009-11-18 Thread Foggi, Nicola
... Thoughts? Nicola -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Foggi, Nicola Sent: Wed 11/18/2009 1:41 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] ExternalAuth TLS to Active DirectoryLDAP_OPERATIONS_ERROR 1 on Bind Hey Everyone, So I got

[rt-users] RTx::WorkFlowBuilder Depends On Question

2009-11-17 Thread Foggi, Nicola
Hey Everyone, I'm working on setting up RTx::WorkFlowBuilder, I have the following in my RT_SiteConfig: Set($WorkflowBuilderStages, { 'approver1-approval' = { content = 'content', subject = 'Architect Approval for Request: {$Approving-Id} -

[rt-users] Upgrade from RT 3.8.4 to 3.8.6 Required Newer Mod_Perl 1.x under Apache 1.3.41

2009-11-05 Thread Foggi, Nicola
Just in case anyone else runs into this, not sure if it was supposed to be this way or not, but after upgrading to RT 3.8.6 from 3.8.4 we were getting an: [error] Can't call method get on an undefined value at perl-home-dir/5.8.6/HTML/Mason/ApacheHandler.pm line 563.\nCompilation failed in

[rt-users] Upgrade from RT 3.8.4 to 3.8.6 Required Newer Mod_Perl 1.x under Apache 1.3.41

2009-11-05 Thread Foggi, Nicola
Just in case anyone else runs into this, not sure if it was supposed to be this way or not, but after upgrading to RT 3.8.6 from 3.8.4 we were getting an: [error] Can't call method get on an undefined value at perl-home-dir/5.8.6/HTML/Mason/ApacheHandler.pm line 563.\nCompilation failed in

[rt-users] Approvals on 3.8.4 not going to ___Approvals Queue and Attachments

2009-11-03 Thread Foggi, Nicola
Hey Everyone, So I've been looking at ways to create approvals, and initially i created my own approval queue called po-approvals, created the template to create the approval ticket in it, that all worked, however, i wasn't getting notified of the pending approval (though i could see it