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

Agile User Asked on March 9, 2022 in Product Collaboration.
Add Comment
1 Answer(s)

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

Agile Angel Answered on March 9, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.