Report to find any RITM's that have no catalog tasks

GB14 · ‎07-15-2020

Hello,

Need help to create a report to find any approved RITM's that have no catalog tasks due to an error or system issue.

Any suggestions?

Thanks.

Jaspal Singh · ‎07-15-2020

Hi Gurbir,

You can create a report as below.

You can leverage this by switiching to new UI for reports. In the Classic UI (old one) you do not have an option of Related list check.

chuckn · ‎06-22-2023

Exactly that I needed! Thank you!

Rafal Rataj1 · ‎07-16-2020

you can create a database view

sc_req_item.sys_id left join sc_taks.request_item

GB14 · ‎07-17-2020

Thanks Rafal. I tried but it's returning was with 0 results.
I was able to create a report based on Jaspal's suggestions. Thanks again 🙂

Tejaswini9 · ‎11-14-2020

Hello @GB ,

Could you please add what extra conditions you added, we are stuck in the same level. If possible the screen shots of report

Thank you!!!

GB14 · ‎11-16-2020

Hey,

sure here it is: