[rt-users] rt-crontool not sending mail, no errors
Hi, I'm trying to use rt-crontool, to send out reminders when a ticket expires due date. The command and output is like this, but no mail is sent: [root@server ~]# /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \ --search-arg 'Queue = The Queue and (Status = open or Status = new)' \ --condition RT::Condition::BeforeDue \ --condition-arg 0d2h3m1s \ --action RT::Action::NotifyGroup \ --action-arg 'm...@domain.se' \ --transaction first \ --template 'Reminder due soon' \ --verbose \ --log debug [3011] [Wed May 20 06:53:26 2015] [debug]: The RTAddressRegexp option is not set in the config. Not setting this option results in additional SQL queries to check whether each address belongs to RT or not. It is especially important to set this option if RT recieves emails on addresses that are not in the database or config. (/opt/rt4/bin/../lib/RT/Config.pm:505) 18079: Using transaction #111037... 18331: Using transaction #113770... Does anyone know, what could be the problem here? And, yes, mailing works, when you for exapmle resolve a ticket from the web interface. BR Fredrik
Re: [rt-users] Help with Scrip for child / dependent tickets
Hi, this is what we use: my $deps = $self-TicketObj-DependedOnBy; while( my $link = $deps-Next ) { next unless $link-BaseURI-IsLocal; my $dep = $link-BaseObj; next if $dep-QueueObj-IsInactiveStatus($dep-Status); $dep-SetStatus('open') unless $dep-HasUnresolvedDependencies; } Chris Am 22.05.2015 um 11:35 schrieb Jon Witts: Hi Aaron, Thanks for sharing your scrip. I think your scrip is similar but not quite what I was wanting to do. Yours seems hardcoded to only check for two child tickets. I would like my scrip to loop through all child tickets and change the status of the parent if all child tickets are resolved… Does anyone have any pointers? I can’t see where this is falling down. Thanks, Jon
[rt-users] Need help searching tickets by requestor custom field
Hello, I’ve defined a custom field on Users I now need to search for Tickets requested by the Users with certain values within that custom field I’d like to know the way to do this with TicketSQL because I’m going to be writing it into a portlet thanks al;
Re: [rt-users] Help with Scrip for child / dependent tickets
Hi Chris, Thanks for the pointer; I will update the scrip accordingly. Thanks, Jon - Jon Witts Director of Digital Strategy Queen Margaret's School Escrick Park York YO19 6EU Telephone: 01904 727600 Fax: 01904 728150 Website: www.queenmargarets.com -Original Message- From: Christian Loos [mailto:cl...@netcologne.de] Sent: 22 May 2015 13:38 To: Jon Witts Subject: Re: Help with Scrip for child / dependent tickets Hi, next unless( $l-BaseObj-Status =~ /^(?:new|open|stalled|pending|planning|holiday)$/ ); Actually this line uses a hard coded list of statuses. Once you change the lifecycle for a queue, this maybe won't work any more. So it is better to use the IsInactiveStatus or IsActiveStatus methods on a queue object, which respects lifecycle changes. Chris
[rt-users] Portlet list of tickets per custom field value (similar to quicksearch portlet)
Hi, I am looking for a way to list amounts of tickets per a custom field value; similar to how the quicksearch portlet shows queues and how many tickets are in them. E.G. I have a custom field for tickets called “Client” so I can record which client the ticket is for. I need a list for the dashboard to show something like: openstalled Client 13 6 Client 21 0 Client 34 9 I have tried using a chart however a crucial feature I need is to be able to click on the client and be sent to a search page with all their tickets, and I don’t know if charts can be made with links like that. I looked at the wiki page on writing portlets and also the mason template for the quicksearch portlet but it is over my head. I have a tiny bit of perl experience but I’m wondering if someone has written a similar script or could point me in the right direction. Thanks! -- Roman Massey