Re: [rt-users] Status change scrip action

2008-01-21 Thread Mathew
You need to force the owner change to Nobody: http://www.gossamer-threads.com/lists/rt/users/69139?search_string=set%20owner%2C%20nobody;#69139 Keep up with my goings on at http://theillien.blogspot.com Steve Cochran wrote: > Well, with the help of the book and the wiki, I have the code to change

[rt-users] Simple Question: CustomField of Type SelectOneValue / How to get the Description from a Scrip/Template?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
Hi RT Users, Just a simple questions (hopefully). Inside a scrip i can get the CF Value with: $Ticket->FirstCustomFieldValue('CFNAME'). If i need to the the corresponding Description to this value, can i get this with: $Ticket->FirstCustomFieldValue('CFNAME')->Description ?!? Small Background to t

Re: [rt-users] Simple Question: CustomField of Type SelectOneValue / How to get the Description from a Scrip/Template?

2008-01-21 Thread Emmanuel Lacour
On Mon, Jan 21, 2008 at 02:38:01PM +0100, Ham MI-ID, Torsten Brumm wrote: > Hi RT Users, > Just a simple questions (hopefully). Inside a scrip i can get the CF > Value with: $Ticket->FirstCustomFieldValue('CFNAME'). If i need to the > the corresponding Description to this value, can i get this with

AW: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
Hi Emmanuel, The error message is getting better ;-) Jan 21 13:53:30 bruchtal-www3 RT: Template parsing error: Can't locate object method "First" via package "Shipment" (perhaps you forgot to load "Shipment"?) at template line 1. Stack: [template:1] This is the correct Template, without any

[rt-users] assign ticket depending on the value of custom field

2008-01-21 Thread Jaroslaw Borgul
Hello. Another simple question for you. I need to assign tickets inside one queue to different users depending on different values in the same custom field. Any ideas? Thanks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community

Re: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Emmanuel Lacour
On Mon, Jan 21, 2008 at 02:56:27PM +0100, Ham MI-ID, Torsten Brumm wrote: > Hi Emmanuel, > The error message is getting better ;-) > > Jan 21 13:53:30 bruchtal-www3 RT: Template parsing error: Can't locate object > method "First" via package "Shipment" (perhaps you forgot to load > "Shipment"?)

AW: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
Shame on me... :-( Tryed it out with this (re read your Mail ;-) !) To: {$Ticket->CustomFieldValues('Occured in Module')->First->Description;} Subject: {$Ticket->Subject} A new ticket has been created in queue HAM.WEBDEV.KNLOGIN.SUPPORT. {$RT::WebURL}Ticket/Display.html?id={$Ticket->id} --

[rt-users] Oracle 9 and Build.html performance

2008-01-21 Thread Emmanuel Lacour
Hi everybody, I'm looking for help or hints on this problem. RT 3.6.5 do the following request when hitting the search page (Build.html, empty, just the query builder) and take 20 seconds to get an empty result from Oracle :( SELECT main.* FROM ( SELECT DISTINCT main.id FROM Users main CROSS JOI

Re: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Emmanuel Lacour
On Mon, Jan 21, 2008 at 03:40:08PM +0100, Ham MI-ID, Torsten Brumm wrote: > Shame on me... :-( > > Tryed it out with this (re read your Mail ;-) !) > > To: {$Ticket->CustomFieldValues('Occured in Module')->First->Description;} > Subject: {$Ticket->Subject} > > A new ticket has been created in qu

AW: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
;-) OK, then i have to go the hard waybut hopefully jesse or one of the RT developers read this mails ;-) Thanks Torsten > Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), > Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark > Reinhardt (S

Re: [rt-users] Oracle 9 and Build.html performance

2008-01-21 Thread Ruslan Zakirov
I'm not that good in oracle's optimizer, but I'm pretty sure that the following index will help you: CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance); Can you add it, generate plan again and sent it to the list, so I can check that it really helps in the way I think it sho

[rt-users] How to get CurrentUser from a scrip written to a CF?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
Hi RT Users, Another small problem. I'm trying to write down the CurrentUser Information acting on a ticket to a CF. I tried this code: my $queue = $ticket->QueueObj; my $actualuser = $session{CurrentUser}->Name; $self->TicketObj->AddCustomFieldValue(Field => 'Assigned_by_SA', Value => $acutalus

Re: [rt-users] How to get CurrentUser from a scrip written to a CF?

2008-01-21 Thread Ruslan Zakirov
$self->Transaction->Creator - id $self->Transaction->CreatorObj - RT::User object On Jan 21, 2008 10:06 PM, Ham MI-ID, Torsten Brumm <[EMAIL PROTECTED]> wrote: > Hi RT Users, > > Another small problem. I'm trying to write down the CurrentUser > Information acting on a ticket to a CF. > > I tried t

[rt-users] Very troubling error

2008-01-21 Thread Mathew
We recently started getting this error which seems to be preventing incoming email from making it into the database: [Mon Jan 21 22:42:30 2008] [warning]: RT::Handle=HASH(0xadd9538) couldn't execute the query 'SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups Groups_1 ON ((Groups_1.Domai

Re: [rt-users] Very troubling error

2008-01-21 Thread Mathew
Additional error prior to the one below: [Mon Jan 21 23:05:37 2008] [warning]: DBD::mysql::st execute failed: Unknown column 'Users_3.id' in 'on clause' at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)

Re: [rt-users] Very troubling error

2008-01-21 Thread Mathew
I think this might be related as well. Seems the Correspondence template is failing. [Mon Jan 21 23:28:14 2008] [error]: Template parsing error: Can't locate object method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at template line 5 Stack: [template:5] [/usr/local/r

Re: [rt-users] Very troubling error

2008-01-21 Thread Ruslan Zakirov
Upgrade to the latest version of DBIx::SearchBuilder module. On Jan 22, 2008 1:46 AM, Mathew <[EMAIL PROTECTED]> wrote: > We recently started getting this error which seems to be preventing incoming > email from making it into the database: > > [Mon Jan 21 22:42:30 2008] [warning]: RT::Handle=HAS

[rt-users] looking for a quick consult... proper list?

2008-01-21 Thread Elijah Wright
Hi, Is it OK to post "hunting a consult" requests here? I checked the list's "welcome" message for a statement of appropriateness; couldn't find anything. Anyway... if this is not the right place, please do direct us appropriately. We're looking for someone to do a few hours of RT consulting fo

Re: [rt-users] Very troubling error

2008-01-21 Thread Mathew
Simple as that? That's a relief. Keep up with my goings on at http://theillien.blogspot.com Ruslan Zakirov wrote: > Upgrade to the latest version of DBIx::SearchBuilder module. > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Co

Re: [rt-users] looking for a quick consult... proper list?

2008-01-21 Thread Mathew
You may want to just get ahold of Best Practical as they make it their business to do this sort of thing. Keep up with my goings on at http://theillien.blogspot.com Elijah Wright wrote: > > Hi, > > Is it OK to post "hunting a consult" requests here? I checked the > list's "welcome" message fo

Re: [rt-users] rt-mailgate HTTPS

2008-01-21 Thread Roy Sowa
That little hint was what I needed , thanks Ruslan It was not intentional, trust me !!! Although everything was working using the GUI, I had numerous ownership and permission confusion throughout my install. The most glaring, carrying over the apache user in my rt group as it was on my original sy

[rt-users] disable autoreply on one queue only?

2008-01-21 Thread Elijah Wright
Hi, we need to do a bulk import of some emails into tickets, but we want to not flood the original requestors with "ticket generation autoreplies". I see that we can disable autoreply by removing the global scrip that does that; however, we don't really want to remove it (and disable autoreplies

AW: [rt-users] How to get CurrentUser from a scrip written to a CF?

2008-01-21 Thread Ham MI-ID, Torsten Brumm
Hi Ruslan, Many thanks for your help. $self->Transaction->CreatorObj wont work for me, played around a little and got success with: $self->TransactionObj->CreatorObj->Name But it was a good hint into the correct direction. Thanks Torsten > Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans