Skip to main content
Nintex Community Menu Bar

Hi , 

I am trying to retrieve assosiated users of a activity from [K2].[ServerLog].[ActInstdest].But i get K2SERVER in User column from  the same [K2].[ServerLog].[ActInstdest]  table .May i know the reason?

 

 

 

Thanks in advance

Hi Naina

 

See below table

  1. [K2].[ServerLog].[ActInstDest]
  • StartDate: Date and time when the activity was started
  • User: Current assigned user

 

  1. [K2].[ServerLog].[ProcInst]
  • Originator: Originator of workflow instance
  • StartDate: Start date of workflow instance

 

  1. [K2].[Server].[ActionActInstRights] (For active instances)
  • This table returns all assigned users (original destination and delegated/redirected) for the workflow instance/activity
  • The ‘ActionerID’ column corresponds to the ‘ID’ column in the [K2].[Server].[Actioner] table so you can obtain the name of the assigned user.

 

  1. [K2].[ServerLog].[ActInstSlot] (For completed instances)
  • User: Final user who actioned on the task
  • StartDate: Date and time when task was assigned to the user
  • EndDate: Date and time when task was actioned by the user

 

Should you find the information from the article useful or leading you to the answer please mark as "Solution and/or Kudo", as it will assist other k2 developers with relevant information in the near future.

 

Best Regards

Elvis

 

[K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member]


Thanks for the Reply, but when i query ACTDEST Table i get K2users in user column. Is it taking server event users as well. Why am i getting K2server as users