Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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 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