Report showing RITMS with No Tasks

terrieb
Tera Guru

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

1 ACCEPTED SOLUTION

Atheher Fathima
Mega Guru

@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

AtheherFathima_0-1683131165596.png


Hope this helps!

View solution in original post

14 REPLIES 14

I see what the problem is. You did sctask_request=ritm_sys_id but your prefix that you did for the sc_req_item table is item. So the where clause should be sctask_request_item=item_sys_id.

Fixed that - same error message when I click try it

 

Hitting the frustration wall.....

Atheher Fathima
Mega Guru

@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

AtheherFathima_0-1683131165596.png


Hope this helps!

Nice, I like this much easier that a database view.

This worked but also returned records with tasks.  Trying to narrow it down to just records with no tasks, in any state on the RITM

 

Any suggestions?