Count No of Requests by a User

Hi Pcorearusa,

Normally, you are able to count it from your own database table by counting by CreatedBy/RequestBy if you save the information once user submitted a request.

The other way to count is to get it from K2 Process Instance table. [K2].[Server].[ProcInst] then filter by CreatedBy.

Finally, Construct a SQL Stored Procedure script to count the number of request then publish it as SmartObject to display in K2 SmartForms.

Regards,

Peter Busto