sql statement to get the performance document current task
Summary:
sql statement to get the performance document current task
Content (please ensure you mask any confidential information):
Hi Team,
I need these below two columns data in the bi report.
- Document Status
- Current Task
I am fallow this below query but I am not getting as expected. I am getting extra columns because of process flow id.
And which code do I need to take for "STEP_CODE"
Select
pn.DISPLAY_NAME Employee_Name,
tp.CUSTOMARY_NAME PD_Name,
trl.MGR_TASK_NAME,
trl.WKR_TASK_NAME,
REPLACE(REPLACE(REPLACE (REPLACE (STEP_STATUS,'COMP','Completed'),'NOTSTR','Not Started'),'INPROG','In Progress'),'READY','Ready') Task_Status,