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 <[email protected]> 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 <
> [email protected]> 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:
>> [email protected]] *On Behalf Of *Dave Barber
>> *Sent:* Tuesday, August 30, 2016 9:49 AM
>> *To:* [email protected]
>> *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"
