How do you generate a report of pending approvals for 2 specific catalog items?

[gk24]

I am struggling to get from sysapproval_approver to sc_req_item, the table I need to get catalog item variables which I also need to be visible on the report. Would appreciate any advice, presently on London but upgrading soon.

[Slawek_Radziewi]

You should be able to get through approval_for and dot walk to Requested Item.Item. 

[gk24]

Thanks for the reply!

So I was originally going to use a database view to connect Approver, RITMs, and Variables (sc_item_option_mtom). However, when using the view as a source it wouldn't show any of the variable fields selected on the report I was trying to generate. I just tried generating a report using your suggestion but it's the same thing 😕 for some reason dot-walking to catalog item fields will not display on the report. Any idea why this may be?

These are the fields I would need on the report:

Number (ritm)
Priority (ritm)
State (ritm)
Short description (ritm)
Task type (ritm)
catalog item field 1
catalog item field 2
catalog item field 3
catalog item field 4
catalog item field 5
catalog item field 6
catalog item field 7
catalog item field 8
Stage 

Greatly appreciate your advice!