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"
