Related list Query for reporting

pramn
Kilo Sage

Hi Team , 

I have requirment below 

Report on sc_req_item table where item.name is ABC

with related list condition where task short description = "XYZ" & state is pending/open

pramn_0-1764586029730.png

 

how do i give Related list condition ?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@pramn 

like this and it will work

Expand the Related List Condition -> Search for Catalog Task -> Request Item and then add conditions

AnkurBawiskar_0-1764586596930.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@pramn 

like this and it will work

Expand the Related List Condition -> Search for Catalog Task -> Request Item and then add conditions

AnkurBawiskar_0-1764586596930.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader