AnsweredAssumed Answered

Join BPM tables

Question asked by CarlosBirlainSelfa82333808 on Jun 27, 2018
Latest reply on Jul 13, 2018 by CarlosBirlainSelfa82333808

Hello everyone.
I need help. I have to make a portlet that shows the responses of the users to the actions of the processes and the object in which it was executed.
I have most of the sql query created:

 

SELECT

 pr.unique_code Cod_proyecto,

pr.name nombre_proyecto,

cp.code Cod_costplan,

cp.name nombre_costplan,

ac.subject asunto_accion,

re.full_name asignado,

asig.status_code respuesta

FROM

niku.odf_project_v2 pr

INNER JOIN

niku.odf_costplan_v2 cp ON cp.object_id = pr.odf_pk

INNER JOIN

niku.bpm_run_objects ro ON ro.object_id = cp.odf_pk AND ro.object_type_code = 'costplan'

INNER JOIN

niku.cal_action_items ac ON ac.object_id = ro.pk_id

INNER JOIN

niku.cal_action_item_assignees asig ON asig.cal_action_item_id = ac.id --AND asig.status_code = 'CAL_CLOSED'

INNER JOIN

niku.srm_resources re ON re.user_id = asig.assignee_id

 

The problem is that I can not connect with this table:

bpm_run_assignees

 

I've been trying for two days and I can not find the solution.
Does anyone know how to join the indicated table (table that contains the answers of the users) with the rest of the query?

 

Thank you very much in advance.

 

Carlos.

Outcomes