Tasks not being listed in dql if not a superuser

tiago.schumann

Hello!

I'm trying to list all human tasks waiting on a document in a specific process. If I run the query as a superuser, it returns all results. If I run as a normal user, it returns only the tasks that he is the performer. Tried to change the supervisor to a group that contains this ordinary users that will monitor the tasks, no success. The acl of the process template includes the relate permission for this group. The query is:

SELECT w.r_object_id, w.r_act_name as Task, d.object_name as Document, i.r_performer_name as Performer, w.r_start_date as Start_Date
FROM dm_workflow w, dmi_workitem i, dmi_package p, bct_docs_pe_geral d , dm_process(ALL)  proc
WHERE i.r_workflow_id = w.r_object_id 
AND proc.r_object_id = w.process_id
AND proc.object_name like 'my_wf'
AND p.r_workflow_id = w.r_object_id
AND i.r_runtime_state in (0,1)
AND p.r_act_seqno = w.r_act_seqno
AND d.r_object_id = p.r_component_id
ORDER BY i.r_creation_date
ENABLE (ROW_BASED)

What should I do to every user in a group get all the query results ?

Best Regards,

Tiago Schumann

Miller-zzMST

Hello Tiago,

Have you tested this dql without bct_docs_pe_geral? May be acl assigned to this object does not allow not superusers to get acces to it?

Please, try this:

SELECT w.r_object_id, w.r_act_name as Task, i.r_performer_name as Performer, w.r_start_date as Start_Date FROM dm_workflow w, dmi_workitem i, dmi_package p, dm_process(ALL)  proc WHERE i.r_workflow_id = w.r_object_id  AND proc.r_object_id = w.process_id AND proc.object_name like 'my_wf' AND p.r_workflow_id = w.r_object_id AND i.r_runtime_state in (0,1) AND p.r_act_seqno = w.r_act_seqno ORDER BY i.r_creation_date ENABLE (ROW_BASED)

~ Konstantin