How to get the open quantity of a process?

1

Hello,
I have a process named “knowledge_management”,
in this process have an action named “km_admin_validate”,
I would like make a accumulation for this process when requester issued this process,
The questions is: how to get the open quantity of the process for an action?

2

Do you mean doing that in Search ?

image
image775×712 23.5 KB

And that will give you the result list with the total count?

image

3

Hello Kevin,
Thanks, I think I got the Open Quantity by using SQL Query.

select count(*) as Qty
from WFACTIVITY_INST a inner join wfprocess b on a.ID_PROCESS=b.ID_PROCESS
where b.name=‘SAE_GY_KNOWLEDGE_MANAGEMENT’
and a.ID_STATE=‘open’