Thank you all, it worked for me :) Naoufal El Hilali
On Fri, Jan 25, 2013 at 4:44 PM, Pargeter, Christie :CO IS <[email protected] > wrote: > ** > > They aren’t copied into the table. You setup the table to point to the > form and setup a qualification.**** > > ** ** > > E.g., the Work info table in ITSM points to the TMS:WorkInfo form with a > qualification of 'TaskOrTaskGroupInstanceId' = $InstanceId$**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 8:17 AM > > *To:* [email protected] > *Subject:* Re: count record in form**** > > ** ** > > ** **** > > Thank you Anusha, Direct SQL seems to be good solution I will try that,*** > * > > ** ** > > Christie, it is a good idea to have a hidden table, but how wil records in > form be copied in the table ?**** > > ** ** > > Regards**** > > > **** > > Naoufal El Hilali**** > > ** ** > > On Fri, Jan 25, 2013 at 4:14 PM, Pargeter, Christie :CO IS < > [email protected]> wrote:**** > > ** **** > > Another option is to put a hidden table on the form and then refresh the > table and do a COLCOUNT($Field$) to get the count too.**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 8:06 AM > *To:* [email protected] > *Subject:* Re: count record in form**** > > **** > > ** **** > > Hi Kiran,**** > > **** > > Thank you for your answer, I dont have database access (login and > password), can use a run SQL in set field ? if yes, how ?**** > > **** > > Thank you a lot**** > > > **** > > Naoufal El Hilali**** > > **** > > On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran <[email protected]> > wrote:**** > > ** **** > > If you have database access, then it’s quite straight forward.**** > > **** > > Select count (*) from Tx à x is a schemaid of a desire form.**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Naoufal El Hilali > *Sent:* Friday, January 25, 2013 9:22 PM > *To:* [email protected] > *Subject:* count record in form**** > > **** > > ** **** > > Hi All,**** > > **** > > I need your help in counting records in a form**** > > **** > > I have an EIE instance that pushes some records to a form, and I wanted to > count the records received by EIE.**** > > **** > > I have created a display only integer field "count"**** > > created a filter that is executed in submit and sets the value of count to > 0 and calls a filter guide**** > > upon its execution the filter guide calls a filter that increment the > count field.**** > > **** > > This development did not work for me, and I see nothing executed in filter > logs**** > > **** > > Thank you all in advance.**** > > **** > > Naoufal El Hilali**** > > _ARSlist: "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_ **** > > _ARSlist: "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"
