<HTML>
<HEAD>
<TITLE>Re: [rt-users] Auto-open Resolved Ticket</TITLE>
</HEAD>
<BODY>
<FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
Set up your environment to know usernam, password and server.<BR>
<a href="http://wiki.bestpractical.com/view/UseRtTool">http://wiki.bestpractical.com/view/UseRtTool</a><BR>
<BR>
On 7/24/09 11:00 AM, "rmp dmd" <rmp.dmd1229@gmail.com> wrote:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Toby,<BR>
<BR>
Thanks for this. <BR>
Please confirm, if I understand your method correctly. <BR>
<BR>
1. Instead of resolving the ticket, after getting my tasks done, put in on stalled and set 'Due date' to next month.<BR>
2. the cron job will re-open this ticket after a month. <BR>
<BR>
If the ticket is re-open, will it send out notification? <BR>
<BR>
im doing the rt-list -i "status = 'stalled' AND due <= 'today'" <BR>
on a command line but it's asking me for a password. <BR>
is my syntax correct?<BR>
<BR>
<BR>
Thanks!<BR>
Roehl<BR>
<BR>
<BR>
<BR>
On Fri, Jul 24, 2009 at 5:08 AM, Toby Darling <darling@ccdc.cam.ac.uk> wrote:<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Roehl<BR>
<BR>
> - I resolved a ticket Subject: Windows Patches or Subject: get and<BR>
> renew certificates<BR>
> - I'll do it again after a month.<BR>
> - RT will re-open this ticket after a month.<BR>
<BR>
I use the Due date field with a stalled status, and have a daily cron job:<BR>
<BR>
#!/usr/bin/perl<BR>
my $cmd = '/usr/bin/rt list -i ';<BR>
my $qry = $cmd . qq/\"status = 'stalled' AND due <= 'today'\"/;<BR>
my @res = `$qry`;<BR>
for (@res) {<BR>
chomp;<BR>
system ("/usr/bin/rt edit $_ set status=open");<BR>
}<BR>
<BR>
I'm sure someone will be along shortly with an rt_crontool solution, or something RESTful.<BR>
<BR>
Cheers<BR>
Toby<BR>
<BR>
<BR>
LEGAL NOTICE<BR>
Unless expressly stated otherwise, information contained in this<BR>
message is confidential. If this message is not intended for you,<BR>
please inform postmaster@ccdc.cam.ac.uk and delete the message.<BR>
The Cambridge Crystallographic Data Centre is a company Limited<BR>
by Guarantee and a Registered Charity.<BR>
Registered in England No. 2155347 Registered Charity No. 800579<BR>
Registered office 12 Union Road, Cambridge CB2 1EZ.<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><BR>
<BR>
Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>