How would you link the question_answer table to the change_request table

[gaynorg]

We have a variable set with Questions for Change Risk Assessment when Changes are logged via the Service Poirtal. The questions and answers are added to the Change form in the 'Change Varaible Editor'

The Change Manager would like to extract teh Questions and Answers into a report to take to CAB

I have found the  question_answer, I can filter on the table name 'change_request', I can filter on the questions start with 'Change_Risk', however this table although linked to the change table, does not allow you to dot walk to the change. I could create a Database View and link the  question_answer table to the change_request table but what field should I use to link them or is there another table that I should be looking at.

[Tim Deniston]

The Table sys Id field on the Question Answers table is the change request's sys_id.

question_answer.table_sys_id = change_request.sys_id

[gaynorg]

thank you

[Aditya Telideva]

You can link by using sys_id. as simpe as that