Here is an example I found on our server. Active Link: AR System Email Template Association Delete on the AR System Email Templates form.
@@:Application-Query-Delete-Entry "AR System Email Association" ( '18001' = "Template") AND ( '18134' = "$Unique Identifier$") AND ( '18000' = "$Attachment GUID Column$") Here is another one Active Link: LDAP AREA:DeleteConf0 IF: @@:Application-Query-Delete-Entry "Configuration ARDBC" '536870913' LIKE "AREA-LDAP-%_$ColumnOrder$" ELSE: @@:Application-Query-Delete-Entry "Configuration ARDBC" ('536870913' LIKE "AREA-LDAP-%") AND (NOT('536870913' LIKE "AREA-LDAP-%[_]%")) Are you doing this in a Run Process action or a Set Fields action using $PROCESS$ ? If you are doing it in a Run Process then try removing $PROCESS$ Jason On Tue, Aug 30, 2016 at 8:07 AM Jason Miller <jason.mil...@gmail.com> wrote: > Hi Dave, > > This is a bit tangent to Application-Query-Delete-Entry but related to > deleting AR System Email Messages (we were recently at 3 mil). We use to do > exactly the same thing; run a query in User Tool --> Delete. Now we use > RRR|Chive to delete. It is nice and gentle on both the AR Server and the PC > it is being run from and does it all in one shot based on a query. > > Check the details on the BMC Communities: > https://communities.bmc.com/message/615453 > > Jason > > On Tue, Aug 30, 2016 at 7:12 AM CRENSHAW, CRYSTAL < > crystal.crens...@ncsecu.org> wrote: > >> ** >> >> Dave, >> >> >> >> We have created an escalation for version 8.1.01. >> >> >> >> The Run If is *'Modified Date' < ($DATE$ - (10 * 86400))* <<We only >> keep 10 days<< >> >> >> >> >> >> And the Run Process is: *Application-Delete-Entry "$SCHEMA$" $Email ID$* >> >> >> >> >> >> Not sure if that will work for your version but hope that helps. >> >> >> >> Thanks, >> >> >> >> >> >> Crystal Crenshaw >> >> Service Management Senior Systems Analyst >> >> Project Services – Service Management >> >> (919)508-0546 >> >> >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Dave Barber >> *Sent:* Tuesday, August 30, 2016 9: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_ >> >> This email may contain confidential and privileged material for the sole >> use of the intended recipient. If you are not the intended recipient, >> please contact the sender and delete all copies. Any review or distribution >> by others is strictly prohibited. Personal emails are restricted by policy >> of the State Employees' Credit Union (SECU). Therefore SECU specifically >> disclaims any responsibility or liability for any personal information or >> opinions of the author expressed in this email. >> >> _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"