Clarity

  • 1.  Join BPM tables

    Posted Jun 27, 2018 01:08 PM

    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.



  • 2.  Re: Join BPM tables
    Best Answer



  • 3.  Re: Join BPM tables

    Posted Jul 13, 2018 12:54 PM

    Thank you very much urmas, your answer has helped me.
    A greeting.