Re: Application-Query-Delete-Entry

[LJ LongWing]

Larry,
Your approach is a bit ‘off’.  An escalation performs a search that matches
your qualification, and then performs your action on ALL records that match
that qualification.  So in this case, I would expect your run-if
qualification to be 

('Status' = "Past") and ($End Date$ < ($TIMESTAMP$ - (86400 * 180)))

Or, whatever qual you want to identify your specific records,

Then, from there, you will be modifying ‘that’ record…so you wouldn’t want
to then perform an Application-Query-Delete-Entry, you could simply perform
an

Application-Delete-Entry $SCHEMA$ $Request ID$



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes
Sent: Thursday, December 08, 2011 10:23 AM
To: arslist@ARSLIST.ORG
Subject: Application-Query-Delete-Entry

** 
Hello Listers,
 
I'm trying to learn how to delete records that are past and the End Date is
more than 6 months prior to todays date.  I built the escalation and when I
run it nothing happens.  Can someone point in the right directions with the
Run Process syntax.
 
I'm using SQL 2008 and Windows 2008.  ITSM is 7.5
 
The form I'm deleting from is:  AP:Alternate
 
Run IF Qualification is:    'Status' = "Past"   (also tried without setting
a Run If Qualification)
 
Run Process is:    Application-Query-Delete-Entry "AP:Alternate" ('Status' =
"Past") and ($End Date$ < ($TIMESTAMP$ - (86400 * 180)))    
       
    I have also tried:    Application-Query-Delete-Entry "AP:Alternate"
('Status' = "Past") and ($End Date$ < ($DATE$ - (86400 * 180))) 
 
 
Thanks in advance for your time,
 
Larry B
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"