Count No of Requests by a User

  • 15 December 2016
  • 1 reply
  • 6 views

Badge +5

In K2 Smartform, how do I display a no of Items or requests a user created? Please help


1 reply

Badge +2

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

 

 

Reply