<div dir="ltr"><div>Hello,</div><div><br></div><div>Basically I want to find tickets with rt-crontool that match the following:<br></div><div><div>Queue = 'Blocks’ AND Status != ‘removed’ AND CF.{ServerClosed} < ’now'</div>
</div><div><br></div><div>The problemI’m encountering, although minor, is that it lists tickets that match that as well as tickets that have no date set whatsoever. The rt-crontool utility displays the date as '1970-01-01 00:00:00’ when I include CF.{ServerClosed} in the -f part of rt-crontool so I thought I’d use that as part of the query. I’ve tried variations on “IS NOT NULL” as != ‘’ and != ‘0’ as well. They act the same as “IS NOT NULL”.</div>
<div><br></div><div><u>This does not return the expected results which is very puzzling:</u></div><div># /opt/rt4/bin/rt ls "Queue = 'Blocks' AND Status != 'removed' AND CF.{ServerClosed} < 'now' AND CF.{ServerClosed} IS NOT NULL" -f 'id,CF.{ServerClosed}'<br>
<b>id CF.{ServerClosed}</b><br>xx454020 1970-01-01 00:00:00<br>xx478114 1970-01-01 00:00:00<br>xx489293 1970-01-01 00:00:00<br>xx489299 1970-01-01 00:00:00<br>xx492598 1970-01-01 00:00:00<br>xx495471 1970-01-01 00:00:00<br>
xx495481 1970-01-01 00:00:00<br>xx506972 1970-01-01 00:00:00<br>xx518388 1970-01-01 00:00:00<br>xx519494 2013-11-20 05:00:00<br>xx525723 1970-01-01 00:00:00<br>xx525730 1970-01-01 00:00:00<br>xx525787 1970-01-01 00:00:00<br>
xx528536 1970-01-01 00:00:00<br>xx528542 1970-01-01 00:00:00<br>xx530465 1970-01-01 00:00:00<br>xx532486 1970-01-01 00:00:00<br>xx532492 1970-01-01 00:00:00<br>xx532556 1970-01-01 00:00:00<br>xx532595 1970-01-01 00:00:00<br>
xx533669 1970-01-01 00:00:00<br></div><div><br></div><div><u>Either does this which is even more puzzling considering the output above:</u></div><div># /opt/rt4/bin/rt ls "Queue = 'Blocks' AND Status != 'removed' AND CF.{ServerClosed} < 'now' AND CF.{ServerClosed} != '1970-01-01 00:00:00'" -f 'id,CF.{ServerClosed}'<br>
<b>id CF.{ServerClosed}</b><br>xx454020 1970-01-01 00:00:00<br>xx478114 1970-01-01 00:00:00<br>xx489293 1970-01-01 00:00:00<br>xx489299 1970-01-01 00:00:00<br>xx492598 1970-01-01 00:00:00<br>xx495471 1970-01-01 00:00:00<br>
xx495481 1970-01-01 00:00:00<br>xx506972 1970-01-01 00:00:00<br>xx518388 1970-01-01 00:00:00<br>xx519494 2013-11-20 05:00:00<br>xx525723 1970-01-01 00:00:00<br>xx525730 1970-01-01 00:00:00<br>xx525787 1970-01-01 00:00:00<br>
xx528536 1970-01-01 00:00:00<br>xx528542 1970-01-01 00:00:00<br>xx530465 1970-01-01 00:00:00<br>xx532486 1970-01-01 00:00:00<br>xx532492 1970-01-01 00:00:00<br>xx532556 1970-01-01 00:00:00<br>xx532595 1970-01-01 00:00:00<br>
<p style="margin:0px">xx533669 1970-01-01 00:00:00<br><br></p></div><div><u>I *can* find tickets where the value is set by doing this though:</u></div># /opt/rt4/bin/rt ls "Queue = 'Blocks' AND Status != 'removed' AND CF.{ServerClosed} < 'now' AND CF.{ServerClosed} > '1970-01-01 00:00:00'" -f 'id,CF.{ServerClosed}'<br>
<b>id CF.{ServerClosed}</b><br>xx519494 2013-11-20 05:00:00<br><div><br></div><div>Is using > "1970-01-01 00:00:00” the only way? Seems like that definite value might be begging for bugs or something if somehow the unset date equals "1970-01-01 0<b>5</b>:00:00” for some reason down the road. I just want to make sure I’m not setting myself up for buggy behaviour in the future.</div>
<div><br></div><div><div>-- <br><div dir="ltr"><div><span style="font-family:arial;font-size:small">Landon Stewart :: </span><a href="mailto:lstewart@iweb.com" style="font-family:arial;font-size:small" target="_blank">lstewart@iweb.com</a><br>
</div><span style="font-family:arial;font-size:small">Lead Specialist, Abuse and Security Management</span><br style="font-family:arial;font-size:small"><span style="font-family:arial;font-size:small">Spécialiste principal, gestion des abus et sécurité</span><br style="font-family:arial;font-size:small">
<span style="font-family:arial;font-size:small"><a href="http://iweb.com" target="_blank">http://iweb.com</a> :: <a href="tel:%2B1%20%28888%29%20909-4932" value="+18889094932" target="_blank">+1 (888) 909-4932</a></span><br>
<div><span style="font-family:arial;font-size:small"><br></span></div><div><span style="font-family:arial;font-size:small"><br>
</span></div></div>
</div></div></div>