Report on RITMs without approval & Task

Rakesh40
Tera Contributor

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

1 ACCEPTED SOLUTION

Have you utilized the right fields:

 

AndersBGS_0-1723027526724.png

 

AndersBGS_1-1723027551545.png

 

Above will give the result as shown below:

 

AndersBGS_2-1723027583674.png

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

11 REPLIES 11

Brian Lancaster
Tera Sage

You would need to create a database view with a left join in order to get RTIMs without tasks for example. Below is a screenshot of one I created for without tasks. You would just need to add the approvals table.

BrianLancaster_0-1722961298369.png

 

Hello @Brian Lancaster  

I tried adding the same but i'm getting a warning message. 

 

Rakesh40_0-1722963214534.png

 

 

Hi @Rakesh40 ,

 

You need to change the order in your database view such that RITM is first where after the other table come, together with change of your where clauses:

AndersBGS_0-1723009372277.png

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/

Hello @AndersBGS 

i made the changes given by you

Rakesh40_1-1723010377685.png

But i can't find the data properly

 

Rakesh40_2-1723010436767.png