This is one of a few situations I've encountered where global fields at the server level would be useful.
If we could create a global field with a lifespan of a transaction (or, in this case, the run of the escalation), that retained its same value across all records (of all forms) across the entire transaction, then you could architect the workflow so that each record increments a global counter and those after the 500th would disregard the operation. There would still be some minimal processing overhead for the the additional records (those over #500), but it should significantly mitigate the issue described. Sorry for the sidetrack. -charlie On Mon, Sep 8, 2014 at 7:58 AM, Vikrant Kulkarni <[email protected]> wrote: > ** > > I would suggest look into RRR|Chive from rrr.se it just works fine in > this case. > On Sep 8, 2014 8:25 PM, "LJ LongWing" <[email protected]> wrote: > >> ** >> I don't believe so, an escalation will always iterate over all records >> that match the qual. >> >> >> On Mon, Sep 8, 2014 at 8:45 AM, MalviyaSaurabh < >> [email protected]> wrote: >> >>> Hi All, >>> I am in the process of archiving records in remedy. I have written an >>> escalation with DSO action written which is working. I have the >>> escalation >>> qualification as >>> ( 'Ticket Closed Date' <= "2/28/2009 11:59:59 PM") AND ( 'Status' = >>> "Closed") AND ( 'Ticket Closed Date' >= "1/1/2009 12:00:00 AM") >>> As over 1 lac record are there in this timespan, there are overhead >>> issues >>> happening at the db level. >>> >>> Is there any way we can have the escalation run in batches of say 500 >>> records present in this qualification. >>> >>> Regards, >>> Saurabh >>> >>> >>> >>> -- >>> View this message in context: >>> http://ars-action-request-system.1.n7.nabble.com/Escalation-qualification-DSO-tp118847.html >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> >>> _______________________________________________________________________________ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _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"
