Re: [rt-users] [SLA] Custom (and very imperfect) solution for parking stalled tickets

2012-06-19 Thread Robert Wysocki
Dnia 2012-06-12, wto o godzinie 18:24 +0400, Ruslan Zakirov pisze: Sorry. Didn't notice that. I'm not sure why you need additional data storage. Additional storage in form of CF's in my solution is merely a product of the lack of time. I needed it to work and the simplest way was then for

[rt-users] Add a Delete link next to the Take link

2012-06-19 Thread Arthur Rance
Hello, I'd like to add a Delete link (to delete a ticket) next to the Take link. How would you do that ?

[rt-users] RES: Multiple queues on one email address

2012-06-19 Thread Diaulas Castro
Here i solved with procmail. We have N mailgroups, each one represent one customer/queue and they point to our rt mail account So if the customer send to one mailgroup, procmail will forward to designed queue. :0 w * ^(Cc|To).*custom...@myorg.com |/usr/bin/rt-mailgate --queue customer1

[rt-users] in sql how do you get to custom fields?

2012-06-19 Thread Lander, Scott
I am using a 3rd party BI tool for some auditing tools here, and am trying to understand the table layout. As part of the project I would like to list for a ticket the Ticket number, creator, creator phone number, created date, the queue, the business unit, and other data. I have figured

Re: [rt-users] in sql how do you get to custom fields?

2012-06-19 Thread Stuart Browne
Hi, If it's a single value selected in the custom field, we generally use something like: SELECT ... PA.Content, ... FROM Tickets T JOIN Users U ON T.Owner = U.id JOIN Queues Q ON T.Queue = Q.id LEFT OUTER JOIN (SELECT ObjectId, Content FROM ObjectCustomFieldValues

[rt-users] Same admin user with two email addresses?

2012-06-19 Thread Gavin Henry
Hi, Is it possible for me as an admin on RT4 to have to emails for my account? For example, I may reply to a ticket from my phone which doesn't have the the current email address that is set on RT so my replies get sent to my main address. If I create a new user then I'll get double emails. What