Hi Fred,
Uh duh of course!!!
--
Regards,
Louise van Hine
[EMAIL PROTECTED]
Quoting "Grooms, Frederick W" <[EMAIL PROTECTED]>:
This is not a valid query
'Request' = "$Request ID$" 'Status-Dtl' = "Pending"
Since all you care about is Status of Pending use
'Status-Dtl' = "Pending"
If you need Request ID and Status of Pending use an AND
'Request' = "$Request ID$" AND 'Status-Dtl' = "Pending"
Think of it as a normal Advanced Query in the User Tool
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of E. Louise van Hine
Sent: Monday, October 29, 2007 2:02 PM
To: [email protected]
Subject:
Can anyone tell me what is wrong with this syntax in the
Application-Query-Delete Entry? The out of box filter just queries for
the Request ID, but I need it to only delete entries with the parameter
where the Status is "Pending."
Can this command take two variables?
Application-Query-Delete-Entry "AP:Detail" 'Request' = "$Request ID$"
'Status-Dtl' = "Pending"
--
Regards,
Louise van Hine
[EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
