Thad Esser That's Brilliant, I did a set field with 1=1 and count = $LASTCOUNT$ and it worked :)
Thank you very much Naoufal El Hilali On Fri, Jan 25, 2013 at 5:27 PM, Thad Esser <[email protected]> wrote: > ** Sounds like you already have an answer, but one other option would be > to do a set fields in combination with LASTCOUNT. > > Action 1: > Set Fields where requestid != $ NULL$ (or some other qualification > that causes a search for all the records you want to count), > tempchar = requestid (set to first match) > Action 2: > Set Fields: > count = $ LASTCOUNT$ (remove the space after the first $) > > That has a little smaller footprint than a table and doesn't involve SQL. > > Thad > > On Fri, Jan 25, 2013 at 9:05 AM, Naoufal El Hilali < > [email protected]> wrote: > >> ** >> 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_ >>> >> >> _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"
