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:
niku.odf_costplan_v2 cp ON cp.object_id = pr.odf_pk
niku.bpm_run_objects ro ON ro.object_id = cp.odf_pk AND ro.object_type_code = 'costplan'
niku.cal_action_items ac ON ac.object_id = ro.pk_id
niku.cal_action_item_assignees asig ON asig.cal_action_item_id = ac.id --AND asig.status_code = 'CAL_CLOSED'
niku.srm_resources re ON re.user_id = asig.assignee_id
The problem is that I can not connect with this table:
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.