Report showing RITMS with No Tasks

terrieb · ‎05-03-2023

Need to find a way to show RITM records that have no tasks created against them. We had a BR fail for creating requests/RITMS without tasks being created even though the flow designs had tasks.

We have since fixed that issue but we just want to ensure that there are no open RITMS with No Tasks lingering out there

I tried creating a report based on the requested item table with the related list condition of Catalog Task -Requested Item but that did not return the correct records - it returned the RITMS WITH tasks, not without tasks.

Thanks

Atheher Fathima · ‎05-03-2023

@tery ,

I tried to 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

Hope this helps!

View solution in original post

Brian Lancaster · ‎05-03-2023

You will need to create a database view with a left join. Here is how the tables should be configured.

This will give you both ritms with and without tasks. So when you use it in a report you will just need to filter on the number from the sc_task table is empty.

terrieb · ‎05-03-2023

Tried that and went it did the "try it" on the database view, got two syntax errors. Is there something wrong in what I inputted?

Brian Lancaster · ‎05-03-2023

I don't see the left join. Make sure you add that to the list layout and set it to true for sc_task table.

terrieb · ‎05-03-2023

I did add the left join field to the view table layout - is this what you mean?