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

[Community Alums]

Hi @cicgordy ,

Yes, you can do that, let me know if you need help in configuring DB views.

[cicgordy]

@Community Alums yes please if you can I'd really appreciate that as I never really built one!

[Community Alums · Accepted solution]

Hi @cicgordy ,

Here u go:

Result:

u got to group by number since its a DB view on multiple table (Mutiple variable are associated to one RITM) column will not come in one row.

Hope this helps.

[cicgordy]

Hi @Community Alums, 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 

[cicgordy]

H i@Community Alums,

 Actually, no need for the last request, I resolved.

Thank you for your help with this!