Carey:
Thanks for the explanation of why an escalation against a form with no records would not run if the qualification was set to 1=1. There are no records to pick from, thus the qualification would fail. Thus, workflow to run must be in the Else action tab (like a set field for instance.)
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Carey Matthew Black
Sent: Saturday, September 02, 2006 3:59 AM
To: [email protected]
Subject: Re: FIXED: arimportcmd on Escalation
Escalations are a bit of an "odd object" in ARS. They are data set driven and not a single "data record" transaction. (Which makes them a bit of a different critter in the ARS universe. More like a Modify All operation, just on the AR server.) Active Links and Filters only really operate on the "current transaction" (or singe data record).
The Escalations Run If is used to "select" N records from a table.
If N > 0 Then
If Actions are executed against each of the N records that was selected.
Else
The "Else Actions" are executed ONCE against a "blank record".(all values null)
The unqualified Run if should work just fine to find any and all records in the form. (If there were any data records in the table.)
A qualification of "1=0" should work just fine to FORCE the Escalation's "Else" behaviour too. But there has also been a long standing debate if that would also force a RDBMS table scan too. So I would suggest that you be conservative and not do something like that against a table that has much data in it just to be safe.
HTH
ARS 101
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 9/1/06, Den Fong <[EMAIL PROTECTED]> wrote:
> **
>
> James
>
> I tried that, and the 1=1 but neither works. Because there are no
> records, the system won't run anything on the if side.
>
> Den
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
