Report on RITMs without approval & Task

[Rakesh40]

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]

Hi @Rakesh40 ,

You need to define which columns that you would like to see:

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

Best regards

Anders

[Rakesh40]

But in this table i'm not able to filter the RITM's without Approvals and Tasks.

[AndersBGS]

Hi @Rakesh40 ,

You should be. that is why you created the two related tables with "left join" true. This refer to, that all RITMs will show no matter if there is tasks or/and approvals attached. After creating the database view, you just need to filter the data to see RITMs without approval or/and task.

What can you see / not see? What errors are you facing now? 

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

Best regards

Anders

[Rakesh40]

Hello @AndersBGS 

I'm getting the data of all the RITMS but RITMs without without approval and tasks data showing as empty.

[AndersBGS · Accepted solution]

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