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.