Showing RITM variable, in the list view of a report that is referencing sysapproval_approver table

[cicgordy]

Hi all,

I created a report referencing the approval table (sysapproval_approver) and added following columns from the approval table: state, approval for, approver and comment, and I also want to display a variable of a catalog item in the column of the report list view, but from the approval table I cannot dot walk to the sc_req_item to get the variable . Any idea how to link the two tables and display the variable as column? I also tried the opposite, such as referencing the sc_req_item table in the report but can't dot walk to approval table to get approval state, approval for, approver and comment columns.

Thanks

[manueleriklego]

Hi @cicgordy  , I am having the same requirements as well, can you share what you did regarding your statement below.
Hi @Hemanth M1, This is great as I was able to get most of the stuff I needed. Only one thing I am not yet getting right, and that's the answer of the variable selected, meaning I want to show a column of that variable name with all the answers(typed as free text when form is submitted), perhaps we need to add sys_id of that question in the database view? Thanks