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
