ARSLIST.ORG<mailto: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.
Awkwa
m:* 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
> *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 realised this could be
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
o:arslist@ARSLIST.ORG] On Behalf Of Dave Barber
Sent: Tuesday, August 30, 2016 6:49 AM
To: arslist@ARSLIST.ORG<mailto: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 run
: 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
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
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 re
uest 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
>
>
>
> **
>
> Be cautious when adding
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 trying
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
:
> 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 required for
> Ap
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' = "$Uniq
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
ay, August 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
**
> 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
: 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 requir
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
**
Al
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
Joe
From: Rod Harris
Sent: Monday, December 12, 2011 8:28 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
** I doubt too many instructors would be taking you on in argument about Remedy
these days Misi. They'd have to be ga
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. If
me 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 that. Thi
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 that
g 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
> &
ps:
> public.remedy.arsystem.general
> 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.
>
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 of
rederick W <
frederick.w.gro...@xo.com> wrote:
> From the Filter log (and this is even from Application-Query-Delete-Entry
> action)
>
>
>
>/* Sat Dec 10
> 2011 13:27:52.0979 */
> Start filter processing (phase 1) -- Operation - DELETE on
> MyFormName - 000
: Saturday, December 10, 2011 11:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry
That shatters a long standing understanding I had about data driven
escalations. I had received this info at a Remedy training facility in
Bracknell in UK years ago, that you ought to help Escala
From the Filter log (and this is even from Application-Query-Delete-Entry
action)
/* Sat Dec 10 2011
13:27:52.0979 */
Start filter processing (phase 1) -- Operation - DELETE on MyFormName -
5840476
As you can see the filters fire using the Escalation thread
al 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 every once in awhilebut you and I seem
to differ in our opinions of how i
t;
> 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
>
&g
l Message-
From: Action Request System 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 t
slist@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
is 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 com
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
nts
the Alternate ID field in the form; found this hiding on the second tab.
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: ars
ill be tied up for exactly the same amount of time regardless
>
> At least, 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
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 as Linda pointed out should be a field on that form you are
searching f
take on a new job..
Joe
-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 matche
Date$ < ($TIMESTAMP$ - (86400 * 180)))
Or, whatever qual you want to identify your specific records,
Then, from there, you will be modifying that record
so you wouldnt want
to then perform an Application-Query-Delete-Entry, you could simply perform
an
Application-Delete-Entry $SCHEMA$ $Requ
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'.
__
nd Windows 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'
Tuesday, October 05, 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: Probl
at as below:@@:Application-Query-Delete-Entry CHG:CABInvitedPeople
'' = "$Infrastructure Change
ID$"where x is the DB ID rather than
namehope that helps.Todd ArnerFrom: Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf
Of tristan.
ual 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.
>
>
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 t
**
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 qualification"But in the documents of ARS there is
the sam
sprüngliche Nachricht-
Von: 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 fro
-Ursprüngliche 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'
ftrag 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 "ACTL"just assumed filters. The
documentation flags Application-Query-Delete-Entry as Filter only, and not
Act
Huh...didn't even notice the Log stating "ACTL"just 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 doc
table 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
> Bet
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...@arsli
est System discussion 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 t
> 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
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 'chkBox
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 'chkBox
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'
Has anybody used "Application-Query-Delete-Entry" ?
Here are an example by Help of Admin Tool:
Application-Query-Delete-Entry "ABC DEF" 'User Name' = "Fred"
I would like to know if is possible to to something like this:
Application-Query-Delete-Entry
> Sent: 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-En
'Souza
> *Sent:* 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-De
Souza
Sent: 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 lo
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
t; > [mailto:[EMAIL PROTECTED] Behalf Of Jarl Grøneng
> > > > Sent: Saturday, October 20, 2007 3:22 PM
> > > > To: arslist@ARSLIST.ORG
> > > > Subject: Application-Query-Delete-Entry and server crash...
> > > >
> > > >
> >
single parameter).
>
> Out of curiosity try that:
> $PROCESS$ @@:Application-Query-Delete-Entry "TMS:Flow"
> ('RootRequestInstanceID' = "$InstanceId$" AND 'ParentID' = "$InstanceId$" AND
> 'Sequence Mode' = "Yes
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' = &qu
inal Message-
> From: Action Request System 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
t: Re: 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' = "
I see... This is the command...
$PROCESS$ @@:Application-Query-Delete-Entry "TMS:Flow"
'RootRequestInstanceID' = "$InstanceId$" AND 'ParentID' =
"$InstanceId$" AND 'Sequence Mode' = "Yes" AND 'Status' = "Pendi
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.
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
>
>
&
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
T
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 in
74 matches
Mail list logo