Check for 'TR.DiaryField' != $NULL$ on your filter... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.
----- Original Message ---- From: "Cupp, Michael E Jr. CTR USAF AFRL/SNOD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, January 29, 2007 4:03:57 PM Subject: Re: Escalation question ** How can I check in the filter to see if the diary field has been updated? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Monday, January 29, 2007 12:11 PM To: arslist@ARSLIST.ORG Subject: Re: Escalation question ** I'm not sure if you can parse through that with an escalation, but you might consider setting a hidden timestamp field through a filter each time the diary field is modified, that way your escalation can just look at that timestamp field. From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of Cupp, Michael E Jr. CTR USAF AFRL/SNOD Sent: Monday, January 29, 2007 10:59 AM To: arslist@ARSLIST.ORG Subject: Escalation question Importance: High Remedy Newby here - I have an escalation that I want to fire for all records with a status of 'Working' and that have not had a diary entry posted in the last 36 hours. I want to set the status to Assigned. How can I compare the most recent diary entry for a ticket's work log field to the current system date/time? --- Michael Cupp, Jr., Contractor, RCF Oracle Database Administrator AFRL EBS Helpdesk Team Lead AFRL/SNOD Enterprise Operations Center Wright-Patterson AFB, Ohio DSN 785-3827 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"