Skip to main content
Nintex Community Menu Bar

Count No of Requests by a User

  • December 15, 2016
  • 1 reply
  • 7 views

Forum|alt.badge.img+5

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

1 reply

Forum|alt.badge.img+2
  • 9 replies
  • January 19, 2017

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