Re: [rt-users] Query Builder - query format

2011-05-18 Thread Ruslan Zakirov
Hello Igor, It's not possible in TicketSQL. In code you can build such query and for example create a portlet. On Wed, May 18, 2011 at 9:44 AM, Igor Mel a...@portaone.com wrote: Hi, mysql supports queries like ... where fieldA = fieldB; and I need (for instance) saved search like  Creator =

Re: [rt-users] Old RT and New RT ?

2011-05-18 Thread aseim99
Ok folks , this is what i have done . In rt-mailgate under /etc/smrsh/ i have created a sub: sub get_id { my $key1; my $value1; while ( my ($key1, $value1) = each(%message) ) { open (FILE, $value1) or die Could not open ;

Re: [rt-users] Date Custom Field in RT 4

2011-05-18 Thread Wayne Thursby
Kenn, I'm not sure how the 3.8 custom patch stores its information, but all RT 4 requires is a string in the Content field of ObjectCustomFieldValues of the form -MM-DD. I wrote a quick script to convert our user input of MM/DD/YY to the other format, and simply changed the custom field type

[rt-users] rt apache running slow

2011-05-18 Thread Chris Hall
Hello all, I'm not sure if was the case before the upgrade to 4.0.0 from 3.8.8, but I've noticed intermittent slowdown.. particularly on the front page. I have a suspect as to why this is the case, and I wanted to know if this could be backed up. The ppl who use rt here requested that resolved

Re: [rt-users] rt apache running slow

2011-05-18 Thread Chris Hall
ok... update... it only seems to do this when I'm going through a proxy server... odd. I can hit it without any trouble inside our network, and from the internet, but when it goes through my squid proxy, it wants to choke out. On Wed, May 18, 2011 at 10:21 AM, Chris Hall hir...@gmail.com wrote:

[rt-users] Tickets for old rt ....how to handle them ?

2011-05-18 Thread aseim99
Hi, We will be running old rt and new rt side by side for 3 months . After that old rt will be shut . so if someone replys to an old email . they will receive a automatic reply that the ticket does not exist. How to create a new ticket in new rt which has a subject something like zxc

[rt-users] Updating saved searches via API

2011-05-18 Thread JP White
We are running RT version 3.8.9 on MySQL. I have a need to rename a bunch of queues (for several reasons) and have been asked to be update ALL saved searches and find/replace queue names. I haven't been able to find any good code examples on how this could be done. I have some code that will

Re: [rt-users] Changing Owner, AdminCC and CC labels

2011-05-18 Thread Yan Seiner
On Tue, May 17, 2011 6:50 pm, Thomas Sibley wrote: On 05/17/2011 04:17 PM, Yan Seiner wrote: Is it possible to change the Owner, AdminCC and CC labels? The roles really correspond to Team Leader, Team Member, and Secondary Requestor the way we're structured and it would make life a bit

Re: [rt-users] Linking to RT from MS Excel

2011-05-18 Thread Yan Seiner
On Wed, May 4, 2011 4:53 pm, Lai Zit Seng wrote: On May 5, 2011, at 7:10 AM, Yan Seiner wrote: On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote: I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. I've tried the hyperlink function and also a directl link; no matter what

[rt-users] Please help - rt4 slow after upgrade

2011-05-18 Thread Chris Hall
Not sure where to start here, but trying to diagnose why after an upgrade from 3.8.8 to 4.0.0 things have slowed down tremendously. Doing even pedestrian tasks such as loading the home screen or opening the ticket search will about 30% of the time decide it wants to max out the cpu with the

[rt-users] RT 4 - install on Debian Squeeze

2011-05-18 Thread Gilbert Rebeiro
Hi, Are there any instructions to install RT 4 on Debian Squeeze? Thanks, Gilbert.

Re: [rt-users] RT 4 - install on Debian Squeeze

2011-05-18 Thread Thomas Sibley
On 05/18/2011 04:38 PM, Gilbert Rebeiro wrote: Are there any instructions to install RT 4 on Debian Squeeze? There is not yet a Debian package for RT 4, but you can easily install from source using the README and docs/ included with the official tarball. Thomas

Re: [rt-users] RT 4 - install on Debian Squeeze

2011-05-18 Thread Alexander Finger
If you want to keep your install clean, try to install the necessary modules using apt-get instead of using fixdeps. rgds Alex On Wed, May 18, 2011 at 10:38 PM, Gilbert Rebeiro gilb...@dido.ca wrote: Hi, Are there any instructions to install RT 4 on Debian Squeeze? Thanks, Gilbert. --

Re: [rt-users] RT 4 - install on Debian Squeeze

2011-05-18 Thread Gilbert Rebeiro
Thanks Alex, That's what I would like to do, does anyone have a list of deps that are available under squeeze? Thanks, Gilbert. On 18/05/2011 5:08 PM, Alexander Finger wrote: If you want to keep your install clean, try to install the necessary modules using apt-get instead of using fixdeps.

Re: [rt-users] RT 4 - install on Debian Squeeze

2011-05-18 Thread Nick Kartsioukas
On Wed, 18 May 2011 23:08 +0200, Alexander Finger a...@genevainformation.ch wrote: If you want to keep your install clean, try to install the necessary modules using apt-get instead of using fixdeps. For our RT install, I found some Perl packages were too old or missing from Debian

Re: [rt-users] rt apache running slow

2011-05-18 Thread Ruslan Zakirov
Hi, Then it's something about headers your proxy server adds to the request. On Wed, May 18, 2011 at 6:30 PM, Chris Hall hir...@gmail.com wrote: ok... update... it only seems to do this when I'm going through a proxy server... odd.  I can hit it without any trouble inside our network, and

Re: [rt-users] Updating saved searches via API

2011-05-18 Thread Ruslan Zakirov
Hi, Saved searches are in Attributes table, so at the end you should get RT::Attribute object. Access -Content, do regexps or something else to rename queues and use SetContent method for update. On Wed, May 18, 2011 at 8:08 PM, JP White jpwh...@hotmail.com wrote: We are running RT version

Re: [rt-users] Please help - rt4 slow after upgrade

2011-05-18 Thread Chris Hall
I actually saw something about that in a message to the mailing list, and already turned it off as well, as a precaution. After searching around some and trying out some tests, it seems the delay happens after the GET request to the apache server, and watching the logs, nothing appears in the

Re: [rt-users] Work with Google Apps?

2011-05-18 Thread Nathan Ward
On 13/05/2011, at 9:28 AM, Gavin Henry wrote: Hi, Can this be done? My RT is configured to use my primary domain, ie. support@mydomain. It receives email at a subdomain - ie. support@rt.mydomain. My primary domain is hosted at Google Apps (for business, not the free one). My RT subdomain