brianlan25
Kilo Patron
In response to terrieb

‎05-03-2023 09:41 AM

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.

0 Helpfuls

terrieb
Tera Guru
In response to brianlan25

‎05-03-2023 10:34 AM

Fixed that - same error message when I click try it

 

Hitting the frustration wall.....

Preview file
88 KB
0 Helpfuls

Atheher Fathima
Mega Guru

‎05-03-2023 09:26 AM

@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

brianlan25
Kilo Patron
In response to Atheher Fathima

‎05-03-2023 09:48 AM

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

0 Helpfuls

terrieb
Tera Guru
In response to Atheher Fathima

‎05-03-2023 10:30 AM

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?

0 Helpfuls