Query Approvers, Observers from Agile DB
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.
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