Hi Misi, My understanding is that it is not recommended to use $LASTCOUNT$ on filters, only in active links, because the $LASTCOUNT$ on a filter will be set for the last filter action that executed at that point in time, which may not be the one that just preceded it. This is specially true were you have many fast and list servers, so the probability of this problem happening is even greater....
Again that's my understanding, so I could be wrong. So therefore anytime that I need to count for records, I prefer to use the select count(*), or even better select count(request_id) or select count(rowid) on oracle databases. I only use the $LASTCOUNT$ keyword on active links, since active links actions are always serially executed as you know. Maybe somebody at BMC (Doug or David Easter) can confirm what actually happens with $LASTCOUNT$ on a filter in an a server that has multiple fast and list servers configured and many operations are always executing, either by the system (escalations, assignment engine, approval server, etc) or by users. For more than 10 years, I have never gotten a clear answer on this issue. Plus of course the internal ARS design may have changed between ARS versions, so whatever somebody thought was true on ARS 4.0 may have been incorrect in ARS 6.0 Guillaume ________________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Misi Mladoniczky [[email protected]] Sent: Friday, April 16, 2010 5:12 AM To: [email protected] Subject: Re: need to design a counter Hi, Why not keep away from direct-sql when it is not absolutely neccessary? FLTR ACTION SET-FIELDS from FormX ('1' > "0") myResult = $1$ ACTION SET-FIELDS from CURRENT TRANSACTION myResult = $LASTCOUNT$ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Raj, > > What is the reason you need that counter? Just to have a total count of > tickets in form 1?? Or is there another reason? > > If you just want a count, I wouldn't create a form. I would have a hidden > field that did a select count(*) from whatever view name that table has in > the underlying database.. > > Cheers > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]]on Behalf Of Raj > Sent: Thursday, April 15, 2010 8:04 PM > To: [email protected] > Subject: need to design a counter > > > Hello all, > There is an integer field on form1. > need to design a counter which increments the count by one for every > submit on form2. > So, need to write a filter on submit of form 2 which increments the > integer field on form 1 by 1 for every submit on form 2.please advise. > thanks, > Raj > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
