Doug, Much appreciated; don't recall having seen the / (or \) reference before.
The archiving option is working perfectly. Regards Dave On 31 August 2016 at 20:01, Mueller, Doug <doug_muel...@bmc.com> wrote: > ** > > Dave, > > > > All the other suggestions about archive and escalations and the like apply > as different ways to get this done. > > > > But, to tell you why what you were doing below doesn’t work and to help > any other users having issues with qualifiers in run processes. > > > > Use $\TIMESTAMP$ instead of $TIMESTAMP$ in the qualifier. > > > > The extra \ is to escape interpretation of the value. As entered, the > TIMESTAMP keyword is expanded as it is processing rather than being a > keyword so you get the syntax error. Putting in the \ will keep it a > keyword and your qualifier should do what you wanted. This syntax is > needed only for situations where you are putting a qualifier inside the > logic of an operation (not in the RunIF but in places where normally the > keyword is expanded during as the operation proceeds). > > > > > > (and I think it is a \. If not, try /…..) > > > > NOTE: Still using the archive or escalation or other mechanism may be the > best answer for your specific situation. I just wanted to explain the > reason that you were having the issue with the qualifier below. > > > > Doug Mueller > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Dave Barber > *Sent:* Tuesday, August 30, 2016 6:49 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Application-Query-Delete-Entry > > > > ** > > All, > > I'm trying to figure out the syntax required for > Application-Query-Delete-Entry .... (Server is running ARS 7.5) > > Trying to keep an "archive" of emails - we have a requirement to keep 6 > months worth in the system (audit trail, proof of sending, etc.), and the > form was actually turning out to be the largest on the system (over 7 > million records - I manually deleted the older ones via the user tool, that > is not fun!). > > In an active link, just trying a simple > > $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" > '3' < ($TIMESTAMP$ - (86400 * 75)) > > The 75 is related to a test system and the data that is on it (would > obviously be changed on live). The query itself is fine against the email > messages form, it just comes up with a qualification error when run via the > active link. > > Any suggestions? I could try an alternative using > Application-Delete-Entry <form> <record ID> and table walking, but that'll > be horrendously inefficient in comparison to Application-Query-Delete- > Entry. > > Regards > > Dave Barber > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"