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 ,

Report on sc_req_item, bring approval filed and variables onto the column as below:

Existing serial number is a variable on the Sample item 123 catalog item, approval is a field on the sc_req_item table

[cicgordy]

Hi @Community Alums , not that simple.

I need other fields from the approval table like: state, approval for, approver and comment. I am unable to dot walk to the approval table from the sc_req_item to display those columns.

[Community Alums]

Hi @cicgordy ,

Thats where it gets tricky when you want more info from the approval table.

variable info as a column is available only on the sc_req_item table even if you do a database view (joining RITM and approval table) you can fetch all the information from sc_req_item and sysapproval_approver table except variable🙄.

[cicgordy]

@Community Alums that's right, but was thinking what if the database view is done from the ritm to cat variables table sc_item_option and then to approvals?