How to find out Activity and associated users

  • 4 April 2018
  • 3 replies
  • 179 views
K

Hi,

How can I do the following by "SQL query" using K2 :

1. Get the name of the owner (Person A) of an activity.

2. Get list of participant(s) for an activity, in case the activity was assigned to a different person (Person B) by owner, and Person B eventually assigns the activity to Person C .

3 replies

K
Userlevel 6
Badge +16

Hi,


 


For point 1, I think you can use Report SmartObjects to accomplish this ((i.e. Activity Instance and Activity Instance Destination).


I'm not sure that you will need a SQL query for this. These SmartObjects are under Workflow General category (SmartObject Service Tester tool > SmartObject Explorer > Workflow Reports > Worklow General)

K

Thanks you for your reply. 

I am actually working on a business report , thats why I am trying to find out the SQL tables/views. 

 

My report should look like this. Can anybody please help me t find out the SQL tables ??.

 

PorcOrActivityIDCreated ByCreate Date(mm-dd-yy)Assignee NameStart Date(mm-dd-yy)End Date(mm-dd-yy)
100DomainJohnDoe1/1/2010   
   DomainMike1/1/20101/2/2010
   DomainJohn1/2/20101/3/2010
   DomainMathew1/3/20101/4/2010
   DomainSarah1/4/20101/5/2010
L
Userlevel 4
Badge +13

Hi kghosh,


 


I believe the tables listed below contain the information you are looking for.


 



  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


 


Hope this helps. 


 


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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings