I'm trying to create a report to improve visibility on our platform into which catalog items are generating approvals. As the sysapproval_approver table has approvals generated off of task records, I can't find a way to actually associate an approval with the RITM and by extension the Item that it was generated from.
My assumption is that I need to create a database view to join sysapproval_approver with sc_req_item to achive this goal, but I'm having some trouble with the database view itself.
I've tried joining the two tables and have included the Request Item Number and Item, as well as the Approval For and Approver on the Approval table, yet when I try to report on approvals created over time grouped by their items, no data is returned.
Is there something I'm doing wrong with my database view, or with my report? Is there an easier way I can potentially generate this report entirely?
