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 <jdso...@shyle.net> 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:arsl...@arslist.org]on Behalf Of Raj > Sent: Thursday, April 15, 2010 8:59 PM > To: arslist@ARSLIST.ORG > 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 <jdso...@shyle.net> 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:arsl...@arslist.org]on Behalf Of Raj > > Sent: Thursday, April 15, 2010 8:04 PM > > To: arsl...@arslist.org > > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
