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_
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
