You will probably need to create a new date/time field...and every time the diary is updated update that date/time field....then fire your escalation off of that field instead of your diary
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF AFRL/SNOD Sent: Monday, January 29, 2007 9:59 AM To: [email protected] 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
