Hi,
in K2 5.0 I want to expose system smart object "Workflow Reports>Workflow Analytics>Task" to all users because they must have visibility of the person who is in charge of the task. If user does not have administrator rights it receives this error message:
it's possible to avoid to set administrator permission to all users and see anyway data?
Workflow Reports>Workflow Analytics>Task visibility to all users
A
It seems like the only right assigned to these users is view rights. Please have a look at the documentation below on the rights needed. The rights required according to documentation is admin.
"This report can only be accessed if you have K2 Administrator rights on the K2 server." https://help.k2.com/onlinehelp/k2appit/UserGuide/1.5_Update6/default.htm#K2_Management_Site/Workflow_Server/Reports/AllProcesses/AllProcesses.htm?Highlight=workflow report
The example below shows how you can assign desired permissions to users: https://help.k2.com/onlinehelp/K2Five/UserGuide/current/default.htm#Tutorials/Build/HelloWorld-Workflow/05AssignRights.htm
Thanks for yuor reply,
we know how to set permissions on the workflow on the workflow but we want to make the data visible to all users without setting these ones
Hello,
Have to tried the workflow reference control(s) and tried to configure them appropriately to display the data you are looking for? These display the information regarding the workflow without having to set permissions to see who is in charge of the task. You will have to do some configuring though as the default settings don't normally include this.
Workflow Controls:
Hello,
Thanks for your reply! The problem is that it's not possible to filter for Process Instance ID. We tried to make a direct query on the table of K2 database:
Thanks for your reply! The problem is that it's not possible to filter for Process Instance ID. We tried to make a direct query on the table of K2 database:
SELECT Slot.[id]
,Slot.[ProcInstID]
,Event.[Name] AS ActiviyName
,Process.[Folio]
,Process.[StartDate]
,Actioner.[ActionerName] AS Destination
,[Status].[Status]
,ProcSet.FullName AS ProcName
FROM [Server].[WorklistSlot] AS Slot
INNER JOIN [ServerLog].[Status] AS [Status]
ON Slot.[Status]=[Status].StatusID
INNER JOIN [Server].[Actioner] AS Actioner
ON Slot.ActionerID=Actioner.ID
INNER JOIN [Server].[WorklistHeader] AS Header
ON Slot.EventInstID=Header.EventInstID
AND Slot.HeaderID=Header.ID
and slot.ProcInstID = Header.ProcInstID
INNER JOIN [Server].[Event] AS Event
ON Header.EventID = Event.ID
INNER JOIN [Server].[ProcInst] AS Process
ON Slot.ProcInstID=Process.ID
INNER JOIN [ServerLog].[ProcInst] AS WFName
ON Slot.ProcInstID= WFName.ID
INNER JOIN [ServerLog].[ProcSet] AS ProcSet
ON ProcSet.ID= WFName.ProcSetID
where GroupName='worklist'
,Slot.[ProcInstID]
,Event.[Name] AS ActiviyName
,Process.[Folio]
,Process.[StartDate]
,Actioner.[ActionerName] AS Destination
,[Status].[Status]
,ProcSet.FullName AS ProcName
FROM [Server].[WorklistSlot] AS Slot
INNER JOIN [ServerLog].[Status] AS [Status]
ON Slot.[Status]=[Status].StatusID
INNER JOIN [Server].[Actioner] AS Actioner
ON Slot.ActionerID=Actioner.ID
INNER JOIN [Server].[WorklistHeader] AS Header
ON Slot.EventInstID=Header.EventInstID
AND Slot.HeaderID=Header.ID
and slot.ProcInstID = Header.ProcInstID
INNER JOIN [Server].[Event] AS Event
ON Header.EventID = Event.ID
INNER JOIN [Server].[ProcInst] AS Process
ON Slot.ProcInstID=Process.ID
INNER JOIN [ServerLog].[ProcInst] AS WFName
ON Slot.ProcInstID= WFName.ID
INNER JOIN [ServerLog].[ProcSet] AS ProcSet
ON ProcSet.ID= WFName.ProcSetID
where GroupName='worklist'
The result is the expected one, except for "status" that in case of the person who take in charge the task is "Allocated" instead of "Open" And "Avalaible" instead of "Allocated" for other users
Reply
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.