How to get pending approvers on a change
How to get pending approvers on a change? i tried using signoff, workflow_process , change_history tables but could not get results
Hello
Try this query
select c.”ID”,c.”CLASS”,c.”SUBCLASS”,c.”CHANGE_NUMBER”,c.”CATEGORY”, c.”STATUS”,c.”REASON_CODE”,c.”ORIGINATOR”,c.”OWNER”,
c.”CREATE_DATE”,c.”RELEASE_DATE”,c.”DESCRIPTION”,c.”REASON”,c.”MODIFYDATE”,c.”OBJVERSION”,c.”DELETE_FLAG”,c.”SUBMIT_DATE”,c.”ROUTE_DATE”,c.”PRODUCT_LINES”,c.”FLAGS”,c.”WORKFLOW_ID”,c.”STATUSTYPE”,c.”FINALCOMPLETE_DATE”,c.”PROCESS_ID”,c.”IN_REVIEW”,s.signoff_status, s.user_assigned, s.user_name_assigned, ch.timestamp, 0, null, null, trunc(sysdate – route_date)
from agile.signoff s join change c on c.process_id=s.process_id join agile.change_history ch on ch.id=s.history_id left outer join agile.agileuser a on s.user_assigned = a.id
left outer join agile.agileuser cm on c.owner = cm.id
where c.statustype = 2 and s.signoff_status = 0
– Raj
