We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

@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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader