Re: [rt-users] 0 tickets found when using custom fields

Can anyone answer to this ? -- Arkadiusz Jakubas Arces Network, LLC http://www.arces.net ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover

Re: [rt-users] 0 tickets found when using custom fields

It this some kind of bug ? 2008/2/14, Arkadiusz Jakubas <[EMAIL PROTECTED]>: > > I extracted sql query ( 'CF.{Approval}' LIKE '1. Pending' ) : > > SELECT COUNT(DISTINCT main.id) FROM (((Tickets main LEFT JOIN > ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId > = '0'))

[rt-users] DBSSchema : How to use ?

Hello, Following the instructions of RT Wiki, I've downloaded the rt-schema-relationships.dot I cannot visualize it in Debdesigner because the program works with xml files. Can anyone help me ? Thanks for your help Horst ___ Le conte

[rt-users] Removing assets with Shredder

Hi, Is it possible to remove assets from AssetTracker with RT-Shredder? Thanks! Alvaro ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover

Re: [rt-users] DBSSchema : How to use ?

On Wed, Mar 05, 2008 at 10:26:17AM +0100, Horst Kriegers wrote: > Hello, > Following the instructions of RT Wiki, I've downloaded the > rt-schema-relationships.dot > I cannot visualize it in Debdesigner because the program works with xml > files. > > Can anyone help me ? Have you tried graphziv

[rt-users] Rép. : Re: DBSSchema : How to use ?

I've tried with graphviz and zgrviewer and it's OK Thanks for your help Horst >>> Le Mercredi, 5. Mars 2008 à 10:57, Roger Gammans <[EMAIL PROTECTED]> a écrit : On Wed, Mar 05, 2008 at 10:26:17AM +0100, Horst Kriegers wrote: > Hello, > Following the instructions of RT Wiki, I've downloaded the

[rt-users] HTML -> Text Filters?

Hi everyone, In this day and age of HTML e-mails, I wonder if there's an RT plugin I could use to convert HTML e-mails to text? I'm getting replies like this in RT on occasion: Message body not shown because it is too large or is not plain text. I could ask clients to at least send their e-mails

Re: [rt-users] history of tickets?

Any ideas on how to make this behave the way that I would like it to? Even pointing me to a path/to/filename maybe? Greg Evans Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Evans Sent: Tuesday, Ma

Re: [rt-users] Every click on a ticket takes 10 seconds

I do think you should see something in mysql slow log except those LOCKs. On Fri, Feb 8, 2008 at 5:26 PM, asklorz <[EMAIL PROTECTED]> wrote: > > When clicking on a ticket, it takes 10 sec for the page to build up. The left > column of the site (the basics, people, more about xxx xxx) builds up i

Re: [rt-users] history of tickets?

http://www.gossamer-threads.com/lists/engine?list=rt;do=search_results;search_forum=forum_3;search_string=%22More%20about%22;search_type=AND&sb=post_time http://www.gossamer-threads.com/lists/rt/users/71732?search_string=%26quot%3BMore%20about%26quot%3B;#71732 On Wed, Mar 5, 2008 at 7:30 PM, Greg

Re: [rt-users] history of tickets?

On Mar 5, 2008, at 11:30 AM, Greg Evans wrote: > Any ideas on how to make this behave the way that I would like it > to? Even > pointing me to a path/to/filename maybe? You can change this by overriding html/Ticket/Elements/ShowRequestor The FromSQL call controls the Status -kevin > ___

Re: [rt-users] history of tickets?

Thanks Guys. Got the change made and now it is working the way I need it to :) You guys are awespme! Greg Evans Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Falcone Sent: Wednesday, March 05, 200

Re: [rt-users] Every click on a ticket takes 10 seconds

Ruslan Zakirov-2 wrote: > > I do think you should see something in mysql slow log except those LOCKs. > Thanks for the answer. No there are no other slow queries. But I could narrow this problem down to the users. I had a mail conversation with Jesse Vincent. Please see below. So this seems

[rt-users] [RTIR] Bulk Abandon - 3.7.13

Has anyone come across this error when trying to do a BulkAbandon on a group of [RTIR] tickets: System error error: Can't call method "CurrentUser" on an undefined value at /opt/ rt3/share/html/RTIR/Elements/UpdateData line 71. context: ... 67: 68: if ( $type eq '

[rt-users] New ticket causes error

My boss created a ticket which is throwing an error: Can't call method "IsLocal" on an undefined value at /usr/local/rt3/lib/RT/URI.pm line 249. Trace begun at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "IsL

[rt-users] New ticket causes error

My boss created a ticket which is throwing an error: Can't call method "IsLocal" on an undefined value at /usr/local/rt3/lib/RT/URI.pm line 249. Trace begun at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "IsLoc

Re: [rt-users] Editing ShowCustomFields file to maintain Custom Field value formatting

On 3/4/2008 10:09 AM, Simon Jester wrote: > 3.6.5 Unsuccessful file changes > > % while ( my $Value = $Values->Next ) { > ><---Added > % $print_value->( $CustomField, $Value ); > <---Added > > % } > When you bring up the page that's not working, do you see your PRE blocks in th

Re: [rt-users] 0 tickets found when using custom fields

Arkadiusz, Is this query you are writing in RT/Ticket SQL or native SQL? I use RT query with custom fields all the time for reporting and have no problem at all. I also use native SQL for other queries on our Oracle DataBase. Using native SQL against the DataBase, however, requires som

[rt-users] Mail setup - forwarding from Exchange

I'm running RT 3.6.6, and have it almost completed. The problem Im running into is, I can't send e-mail to the server running it. I have Exchange 2003 where the e-mail distribution list is set up which has [EMAIL PROTECTED] and [EMAIL PROTECTED] listed as it's SMTP addresses. When I send an e-ma

Re: [rt-users] Editing ShowCustomFields file to maintain Cu stom Field value formatting

Simon Jester hostile.org> writes: Okay, issue resolved. One of the programmers here pointed out that I'd picked the wrong place for the insertion and showed me were it *should* go. Much thanks to everyone who responded off-list (Todd Chapman, Joe Casadonte) for their assistance. Sorry, Todd,

Re: [rt-users] Mail setup - forwarding from Exchange

Juan, On your exchange server you need to make a new SMTP connector - go into Exchange System Manager| Administrative Groups| MAIN (or your group name)| Routing Groups | | Connectors and then make a new connector. You will tell it that anything going to [EMAIL PROTECTED] will be sent to your RT

Re: [rt-users] Mail setup - forwarding from Exchange

James, thanks! That did it! I think this normally would have worked without having to set up a new connector, but since our default connector for the domain uses an outside server for spam filtering/monitoring, it didn't know this internal server existed, which makes the message I was getting mak

[rt-users] On Queue Change, what queue scrip acts?

I am trying to set up scrips for my queues so that when a queue is changed, the owner in the new queue is set to a default queue owner for that new queue. It is not working. I have some questions about when the scrips are runWhen the onQueueChange scrip is run, is it run from the old queue's s

[rt-users] rt shell script: can't create multi-line text in new ticket

Hello! I've been working on a script that checks to see if a ticket exists for a certain problem, and if not, creates the ticket. I'm using bash with bin/rt to script this, and have been struggling for a few hours trying to get it just right. I have all my data in variables, and this caused me t