AnsweredAssumed Answered

Query action items notes with related project and changes

Question asked by metin.ornek on Mar 25, 2014
Latest reply on Mar 26, 2014 by metin.ornek

Hello

I have Change Request processes. An action item is send to manager depending on workflow conditions. Manager enters notes into action items.

We need to query Project Code, Project Name, Change Request Code, Action Item Subject, Action Item Notes

I have a solution for notes below, but I couldn't relate this with project and change request tables.

King regards

 

select csu.id, userId, csu.first_name||' '||csu.last_name username, bran.id noteId, to_char(bran.note),bra.ai_status_code aiStatus,

brs.id bsId,brsar.id actionId, brs.step_id stepId,bran.created_date noteCreateDate

from

bpm_run_assignees bra left outer join bpm_run_assignee_notes bran on bra.id=bran.run_assignee_id,

BPM_RUN_STEP_ACTION_RESULTS brsar,

cmn_sec_users csu,

bpm_run_steps brs,

bpm_run_processes brp

where

brs.process_instance_id=brp.id and

brsar.step_instance_id=brs.id and

bra.pk_id=brsar.id and csu.id=bra.user_id

and bra.ai_status_code not IN('CAL_OPEN')

and brs.status_code='BPM_SIS_DONE'

and brs.process_instance_id=6349960 -- my process id

 

Outcomes