Skip to main content

Hi

 

I am digging a bit into K2 database and understand it better. 

 

I know that within the K2 database:

1) ServerLog,ActInstDest table holds data about current active processes and user info to whom tasks are assigned.

2) K2 updates the above table with new user details when a current user "redirects" its task to another user.

 

However, when a current user "Shares" its task with a new user, K2 does not update the above table and saves this share slot info in another table.

 

In which table within K2 Database does K2 save the user details with whom a current user share its task with?

 

Example:

User A has a task to action. User A shares its task with User B. Where does K2 save this "Share" in K2 database?

 

Thanks

Hi AbdulRehman,


 


Depending on what version of K2 you are using typically you would find this information within the Activity Instance Audit SmartObject.


To get to the SmartObject:


 



  • Open the SmartObject services tester tool

  • Navigate to "SmartObject Explorer">WF Reports>Workflow General>Helper> Activity Instance Audit.

  • Execute the “List Activity Instance Audit” method - you can execute the SmartObject with or without parameters

  • In the table, under the “Audit Description” Column is where you’ll find the user’s details responsible for the share/redirect and the user who the task has been redirected/shared to. In other words both users will be listed in the column starting with the Originator and Targeted user.


If the SmartObject doesn't excist in the above mentioned diretory then you may have to first register an instance of the ServiceObject inside the SmartObject services tester tool:


 



  • Navigate to ServiceObjects Explorer > WF Reports > Workflow General > Activity Instance Audit Service Object

  • Right click and create SmartObject

  • In the Publish SmartObject window, check that the name of the smart object the doesn’t exist, then assign it to the desired category then click Publish SmartObject

  • Open K2 Workspace

  • Click on the Report tab>Report Designer

  • Click on the “Create Report” button

  • In the create report wizard – Report info and type, enter a name for the report and select the Tabular Reports under the Report Type tab. Then click next.

  • Under the create report wizard – Data Source, choose the Activity Instance Audit SmartObject your created in the previous steps then click next.

  • In the create report wizard – Data layout, Drag and drop the columns you would like to see in the report from the left pane into the right – Audit Description should be one of them. Then click next

  • In the create report wizard – Summarize the data, click next.

  • In the create report wizard – Filter the data, click next.

  • In the create report wizard – Report Parameters, click next.

  • In the create report wizard – Finish, save the report in a desired category then you can view the report.


 


The destination user who have shared/redirected a task with a targeted user will be listed under the Audit Description column

You will have to look at the Activity Audit

[ServerLog].[ActInstAudit]

This audit will have an entry based on ProcInstID with a description like "Worklist item Task delegated from K2:DENALLIXAdministrator to K2:DENALLIXBOB"

HTH
Vernon

I am sure following tables will help you with what you are looking for:

    1. Server.ActionActInstRights

    2. Server.ActionActInstShared

 

Please mark this as answered if it helps resolve your issue]

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings