Re: [rt-users] Looking for script to autoclose ticket

2014-03-12 Thread j.hubbard
Try the below scrip applied directly to whatever queues you want Tickets immediately resolved on. As for notifications that depends on how you have those scrips setup. If the reply scrip is global you should change that to apply only to queues you want replies sent out for. Condition: On Create

Re: [rt-users] Limit Notifications on one Queue but Tickets traveling to another, more verbose Queues.

2014-03-10 Thread j.hubbard
Hi, this is possible. >From what you are trying to accomplish all you should have to do is change the notification scrip to use a user defined condition then use something similar to the below for the condition. #--begin condition-- if (($self->TransactionObj->Type eq "Set") and ($self->Transa

Re: [rt-users] MySQL Question (joins and stuff)

2014-03-04 Thread j.hubbard
Hi Landon, below is some sql I wrote (I'm not too good at sql so some of it could probably be optimized). It pulls a bunch of fields both system and custom as well as the first comment on the ticket and names the columns something friendly. Also it compensates for timezones since the db is in UTC

[rt-users] Set Time Worked to display in Hours on search results

2014-03-03 Thread j.hubbard
I've searched around but haven't found a definitive answer to this. How can I set the "Time Worked" to display in Hours on search results the way "Time Left" does? Any help is very much appreciated. Thanks -- View this message in context: http://requesttracker.8502.n7.nabble.com/Set-Time-Wo

[rt-users] How to change the display of Date Time Custom field in Email

2014-02-12 Thread j.hubbard
Hi, I have searched around for a while now and cannot find an answer so far. I have a DateTime Custom field called "Effective". The value of this field is sent out in emails on ticket creation. So far I have changed settings in RT_SiteConfig for $DateTimeFormat and $DateDayBeforeMonth but thos