I don't understand why you want to store that information when you can do a lookup at any point of time and get the latest count using a select count(*) using whatever conditions you may want to, to count the work log entries that have that specific value that you want to run a count on..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Ravi Sent: Thursday, April 15, 2010 9:55 PM To: [email protected] Subject: Re: {Remedy ARS} Re: need to design a counter ** Joe, This should happen only On Submit on HPD:WorkLog and the integer field to be incremented is on HPD:HelpDesk form. So how can this be done with a filter and an active link, please elaborate. Appreciate your help. Thanks, Raj On Thu, Apr 15, 2010 at 6:07 PM, Joe D'Souza <[email protected]> wrote: Raj, The same can be done using the sql count as suggested earlier.. select count(*) from HPD_Worklog where comment = 'particular value' If that particular value is embedded in the text in the comment field, then you might want to use a like search select count(*) from HPD_Worklog where comment like '%particular value%' Run this in a Set field using an SQL and return the $1$ to that field whenever you want lets say window open, using a active link, and set the count to your integer field. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:59 PM To: [email protected] Subject: Re: {Remedy ARS} Re: need to design a counter Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'="Particular Value") qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza <[email protected]> wrote: > 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"
