Query Approvers, Observers from Agile DB

Hi Everyone,

I am trying to query change order approvers and observers from Agile DB, but I am unsuccessful to even find the data in Agile DB tables.
is this even doable via sql queries?
Any help on this will be appreciated.

Thanks,
Abdellah

Add Comment
1 Answer(s)

It’s doable – I was working on that same thing today.  
Use the SIGNOFF table and you’ll need to join the CHANGE_NUMBER column of the CHANGE table with the ID of the CHANGE_ID of the SIGNOFF to be able to easily specify the ECO number.  Also note that SIGNOFF_STATUS is a column where 0 = they didn’t sign, 2 = they did sign, and 4 = they were an observer. 

Available columns include:
CHANGE_ID, CREATED, FLAGS, HISTORY_ID, ID, JOB_FUNC, LAST_UPD, PROCESS_ID, REQUIRED, SIGNOFF_HISTORYID, SIGNOFF_STATUS, USER_ASSIGNED, USER_NAME_ASSIGNED, USER_NAME_SIGNED, USER_SIGNED, VERSION

Agile Angel Answered on October 24, 2017.
Add Comment

Your Answer

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