Total of listed items

[Perzival]

I have a DataPage which passes parameter to a new DataPage. Then the parameter will filter all the records that has the same value.

Now, I wanted to have a total of those listed in that list.

I was told to use an SQL. I tried this: SELECT COUNT(Item_ID) FROM ORDER_table

But it is returning me the whole count of my Item_ID

Any ideas?

[Harbinger]

I have implemented similar use case from the past.

I got mine sorted out by using .target=[@filed].

You can try and see if that will work for you.

Say:

SELECT COUNT(Item_ID) FROM ORDER_table = target.[@field:Item_ID]

 

Let me know if this helps.

[Perzival]

It worked! I thought it would be more complex.. Thanks.