Report on RITMs without approval & Task

Rakesh40 · ‎08-06-2024

Hello Everyone,

I want to create a report on Open RITMs without Approvals and Tasks.

I trying create but i can't find the right conditions to filter it out.

Can you please help me on this.

Thanks

AndersBGS · ‎08-07-2024

Have you utilized the right fields:

Above will give the result as shown below:

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Adelekan_Muneer · yesterday

Thank you, AnderBGS
This works perfectly for me.

Sumanth16 · ‎08-06-2024

Hi @Rakesh40 ,

create a report on sc_req_item table and under filter, we have an option "Related List condition" select that as equal to 0 and the table can be Catalog Task Request Item, I was able to fetch a report of RITM's that did not have an task.

Please mark as helpful/correct if it helps.

Thanks & Regards,

Sumanth Meda

Rakesh40 · ‎08-06-2024

Hello @Sumanth16
Where can i add the table for Approvals??

i want RITMs without both Approval and Tasks in the same report.

Thanks