cascade;
and don’t forget to rebuild the indexes as well.
Regards
Conny
Von: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Dave Barber
Gesendet: Donnerstag, 1. September 2016 15:39
An: arslist@ARSLIST.ORG
Betreff: Re: EXTERNAL: Application-Query-Delete
eller
>
>
>
> *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
>
>
>
> **
>
>
arber
> *Sent:* Wednesday, August 31, 2016 2:55 AM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: EXTERNAL: Application-Query-Delete-Entry
>
>
>
> **
>
> Todd,
>
> Regardless of the method used (archiving, or application-query-delete-entry),
> I realis
I learn something new
Thanks
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, August 31, 2016 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
**
Fred,
The key is to not have the keyword
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, August 31, 2016 12:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
**
Would using the Slash (and no Double Quotes) make the keyword be treated as the
number value in the Run
e keyword ( “$TIMESTAMP$” ) it would expand to
'3' < (“08/31/2016 2:10:00 PM” - (86400 * 75))
Fred
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, August 31, 2016 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-
: 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 mon
Wednesday, August 31, 2016 2:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Application-Query-Delete-Entry
**
Todd,
Regardless of the method used (archiving, or application-query-delete-entry), I
realised this could be a problem - I've already (manually) cleared down the
email messages form
Todd,
Regardless of the method used (archiving, or
application-query-delete-entry), I realised this could be a problem - I've
already (manually) cleared down the email messages form.
Awkward though, as I had set it to run overnight and delete a small data
set (should have only been 21 records
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Arner, Todd
> *Sent:* Tuesday, August 30, 2016 11:39 AM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: EXTERNAL: Application-Query-Delete-Entry
>
>
>
> **
>
&
tem discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Tuesday, August 30, 2016 11:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Application-Query-Delete-Entry
**
Be cautious when adding the archiving, especially if the first night it runs if
it will be try
the back log was
processed.
Todd Arner
Great Lakes
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave Barber
Sent: Tuesday, August 30, 2016 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Application-Query-Delete-Entry
**
I had
ussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Dave Barber
> *Sent:* Tuesday, August 30, 2016 9:49 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Application-Query-Delete-Entry
>
>
>
> **
>
> All,
>
> I'm trying to figure out the syntax re
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$"
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 Ser
30, 2016 8: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
il.com> wrote:
> **
> 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 (au
: Tuesday, August 30, 2016 9:49 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: 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
Dave,
We have created an escalation for version 8.1.01.
The Run If is 'Modified Date' < ($DATE$ - (10 * 86400)) <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
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 t
sense) is if you need to override filter phasing during the
run
of an escalation..
Joe
-Original Message-
From: Misi Mladoniczky
Sent: Saturday, December 10, 2011 4:04 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Hi,
Filters triggered by an Escalation, either via Set-Fields or Push-Fields,
will ALWAYS be run in the same thread.
This has ALWAYS been the case.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
Hi,
I have doe quite some testing with deleting entries.
The problem with Application-Query-Delete-Entry is that it is treated as
ONE database transaction. That means that the database needs to be able to
roll back the delet, and copies everything to a transaction-space or
something like
with deleting entries.
The problem with Application-Query-Delete-Entry is that it is treated as
ONE database transaction. That means that the database needs to be able to
roll back the delet, and copies everything to a transaction-space or
something like that. This all makes it choke, if it is too
Hi,
If your children is to be deletet, I think that a
Application-Query-Delete-Entry call would be the cleanest way to go.
If the child does not want to be deleted, it can send an Error.
If you do a push, the database will be updated, and the modify-filters
will run, which seems unnecessary
-
From: LJ LongWing
Sent: Thursday, December 08, 2011 2:18 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Joe,
I know this discussion comes up every once in awhilebut you and I seem
to differ in our opinions of how
this
but it makes sense) is if you need to override filter phasing during the run
of an escalation..
Joe
-Original Message-
From: Misi Mladoniczky
Sent: Saturday, December 10, 2011 4:04 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete
From the Filter log (and this is even from Application-Query-Delete-Entry
action)
FLTR TID: 4027734928 RPC ID: 001637 Queue: Escalation Client-RPC:
390603
USER: AR_ESCALATOR (Pool 1) /* Sat Dec 10 2011
13:27:52.0979 */
Start filter
frederick.w.gro...@xo.com wrote:
From the Filter log (and this is even from Application-Query-Delete-Entry
action)
FLTR TID: 4027734928 RPC ID: 001637 Queue: Escalation
Client-RPC: 390603
USER: AR_ESCALATOR (Pool 1) /* Sat Dec 10
2011 13:27:52.0979 */
Start
again to what I
was taught :-)
Joe
From: Jason Miller
Sent: Saturday, December 10, 2011 4:49 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
** On the note of waiting for an Escalation to run have you noticed in recent
releases
2008. ITSM is 7.5
The form I'm deleting from is: AP:Alternate
Run IF Qualification is:'Status' = Past (also tried without
setting a Run If Qualification)
Run Process is:Application-Query-Delete-Entry AP:Alternate
('Status' = Past) and ($End Date$ ($TIMESTAMP$ - (86400 * 180
Try
Run Process is:Application-Query-Delete-Entry AP:Alternate ('Status' =
Past) and ('End Date' ($TIMESTAMP$ - (86400 * 180)))
'End Date' is the field on the form like 'Status'.
___
UNSUBSCRIBE or access ARSlist
-Original Message-
From: LJ LongWing
Sent: Thursday, December 08, 2011 12:54 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Larry,
Your approach is a bit ‘off’. An escalation performs a search that matches
your qualification
)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, December 08, 2011 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
End Date as Linda pointed out should be a field on that form you are
searching for, represented by 'End Date' in the qualification
, that's my understanding :)
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, December 08, 2011 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
End Date
.
Thanks again,
Larry B.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Thursday, December 08, 2011 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
** I was thinking
to the database name of that field, it will always
work..
Joe
From: Larry Barnes
Sent: Thursday, December 08, 2011 3:10 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
**
First, let me thank you for all the input.
I struggled
this is obsolete
now?
I wish I had a server to verify this :-)
Joe
-Original Message-
From: LJ LongWing
Sent: Thursday, December 08, 2011 2:18 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Joe,
I know this discussion comes up
@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Now that you remind me, I actually remember discussing this once with you..
I'll really need to log the workflow to see what thread processes the filter
workflow when filters are executed triggered by the AR_ESCALATOR user.
I was told
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, December 08, 2011 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
Now that you remind me, I actually remember discussing this once with
you..
I'll really need to log
**
Hi,I
have a problem with the command in an AL@@:Application-Query-Delete-Entry CHG:CABInvitedPeople 'Change
ID+' = $Infrastructure Change
ID$Im getting alwayws the error message
error in the qualificationBut in the documents of ARS there is
the same example with the correct arguments.Any advice
I am going off my memory here so I could be wrong. We could not get it
to work formatted like it is in the manual either. I think we had to
format as below:
@@:Application-Query-Delete-Entry CHG:CABInvitedPeople '' =
$Infrastructure Change ID$
where x is the DB ID rather than
either. I think we had to format as
below:
@@:Application-Query-Delete-Entry CHG:CABInvitedPeople '' =
$Infrastructure
Change ID$
where x is the DB ID rather than name
hope that helps.
Todd Arner
--
*From:* Action Request System
**
Hi,Many thanks, i
solved the issue already.Life is a
bitch.Tristan-Original
Message-Date: Tue, 05 Oct 2010 14:20:19 +0200Subject:
Re: Problems with the Command Application-Query-Delete-EntryFrom:
Rick Cook remedyr...@gmail.comTo:
arslist@ARSLIST.ORG** Yup. It's
, 2010 7:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problems with the Command Application-Query-Delete-Entry
**
Hi,
Many thanks, i solved the issue already.
Life is a bitch.
Tristan
-Original Message-
Date: Tue, 05 Oct 2010 14:20:19 +0200
Subject: Re: Problems with the Command
Hi Friends,
I am facing problem with 'Application-Query-Delete-Entry' process.
I have written this action like this:
Application-Query-Delete-Entry KP_UserApplicationForm
'chkBoxApplicationStatus' = Delete
to delete all the record for which 'chkBoxApplicationStatus' =
Delete.
while running
Hi Friends,
I am facing problem with 'Application-Query-Delete-Entry' process.
I have written this action like this:
Application-Query-Delete-Entry KP_UserApplicationForm
'chkBoxApplicationStatus' = Delete
to delete all the record for which 'chkBoxApplicationStatus' =
Delete.
while running
:
Hi Friends,
I am facing problem with 'Application-Query-Delete-Entry' process.
I have written this action like this:
Application-Query-Delete-Entry KP_UserApplicationForm
'chkBoxApplicationStatus' = Delete
to delete all the record for which 'chkBoxApplicationStatus' =
Delete.
while running
list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kaushal Pandya
Sent: January 8, 2009 12:28 PM
To: arslist@ARSLIST.ORG
Subject: Application Query Delete Entry
**
Hi Friends,
I am facing problem with 'Application-Query-Delete-Entry' process.
I have written this action like
If you're using this in an AL you must precede the command with @@: The AL runs
on the client and try's to start an executable file named
Application-Query-Delete-Entry.
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im
an executable file named
Application-Query-Delete-Entry.
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von ccrashh
Gesendet: Donnerstag, 8. Januar 2009 12:53
An: arsl...@arslist.org
Betreff: Re: Application
Huh...didn't even notice the Log stating ACTLjust assumed
filters. The documentation flags Application-Query-Delete-Entry as
Filter only, and not Active Links. Does the lack of a checkbox mean
it will work but isn't supported? Or is this just another example of
bad documentation
von ccrashh
Gesendet: Donnerstag, 8. Januar 2009 14:11
An: arslist@ARSLIST.ORG
Betreff: Re: Application Query Delete Entry
Huh...didn't even notice the Log stating ACTLjust assumed filters. The
documentation flags Application-Query-Delete-Entry as Filter only, and not
Active Links. Does
Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von ccrashh
Gesendet: Donnerstag, 8. Januar 2009 14:11
An: arsl...@arslist.org
Betreff: Re: Application Query Delete Entry
Huh...didn't even notice the Log stating ACTLjust assumed
: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von ccrashh
Gesendet: Donnerstag, 8. Januar 2009 14:53
An: arslist@ARSLIST.ORG
Betreff: Re: Application Query Delete Entry
But won't this process, because it is initiated from the client-end, force the
client
Yes, You could use this command from the Run Process or the setfield action
and define a qualification with values to be determined at run time.
Here is one of sample that works
Application-Query-Delete-Entry AR System Email Attachments ('18254' = 1
AND '179' = $Destination ID$)
AF
On Fri, May
: Monday, October 29, 2007 2:02 PM
To: arslist@ARSLIST.ORG
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
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG ] On Behalf Of Joe D'Souza
Sent: Monday, October 22, 2007 2:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry and server crash
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Application-Query-Delete-Entry and server crash...
** A workaround in case its a bug and you cannot use the
Application-Query-Delete-Entry would be to use Application-Delete-Entry
using a AL guide. Use the AL guide to loop through the records that have
discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Jarl Grøneng
Sent: Sunday, October 21, 2007 2:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry and server crash...
I see... This is the command...
$PROCESS$ @@:Application-Query-Delete-Entry TMS:Flow
I have always had problems with the Query-Delete-Entry unless I put the query
string inside parenthesis (so it see's the query as a single parameter).
Out of curiosity try that:
$PROCESS$ @@:Application-Query-Delete-Entry TMS:Flow
('RootRequestInstanceID' = $InstanceId$ AND 'ParentID
).
Out of curiosity try that:
$PROCESS$ @@:Application-Query-Delete-Entry TMS:Flow
('RootRequestInstanceID' = $InstanceId$ AND 'ParentID' = $InstanceId$ AND
'Sequence Mode' = Yes AND 'Status' = Pending)
Fred
-Original Message-
From: Action Request System discussion list(ARSList
:22 PM
To: arslist@ARSLIST.ORG
Subject: Application-Query-Delete-Entry and server crash...
Hi,
We see that the server crash when running this active link:
INT:CHGTMS:CRQ:ChangeSequence_OneLevelUp_ReBuildFlow
This does a Set Field with a $PROCESS\$ Application
A workaround in case its a bug and you cannot use the
Application-Query-Delete-Entry would be to use Application-Delete-Entry
using a AL guide. Use the AL guide to loop through the records that have to
be deleted, and pick the Entry ID of each of these records and use the
Application-Delete-Entry
: Monday, October 22, 2007 2:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry and server crash...
**
A workaround in case its a bug and you cannot use the
Application-Query-Delete-Entry would be to use Application-Delete-Entry
using a AL guide. Use the AL guide to loop through
I see... This is the command...
$PROCESS$ @@:Application-Query-Delete-Entry TMS:Flow
'RootRequestInstanceID' = $InstanceId$ AND 'ParentID' =
$InstanceId$ AND 'Sequence Mode' = Yes AND 'Status' = Pending
However, the active link runs fine on path 2, but with patch 4 the
server crash...
--
Jarl
: Application-Query-Delete-Entry and server crash...
I see... This is the command...
$PROCESS$ @@:Application-Query-Delete-Entry TMS:Flow
'RootRequestInstanceID' = $InstanceId$ AND 'ParentID' =
$InstanceId$ AND 'Sequence Mode' = Yes AND 'Status' = Pending
However, the active link runs fine on path 2
Hi,
We see that the server crash when running this active link:
INT:CHGTMS:CRQ:ChangeSequence_OneLevelUp_ReBuildFlow
This does a Set Field with a $PROCESS\$ Application-Query-Delete-Entry.
If we change the active link to do a Run Process
@@:Application-Query-Delete-Entry, this shows up
Jarl,
What's your query on the run process following the command
Application-Query-Delete-Entry
Joe D'Souza
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Jarl Grøneng
Sent: Saturday, October 20, 2007 3:22 PM
To: arslist
Thats no problem, can query the string, and also delete them manually.
--
Jarl
On 10/21/07, Joe D'Souza [EMAIL PROTECTED] wrote:
**
Jarl,
What's your query on the run process following the command
Application-Query-Delete-Entry
Joe D'Souza
-Original Message-
From: Action
I think what he's asking is, what do you have on the Run Process line?
@@:Application-Query-Delete-Entry something something
Wants to know what the something something is :)
Just copy and paste the whole line into here. Easier to troubleshoot if you
can see the exact syntax.
Dylan
71 matches
Mail list logo