Get the query from the related list on form view

Nisar3
Giga Guru

When I try to copy the query, I'm getting the following message

Nisar3_0-1740570945671.png

 

This is on the metric_instance table if that helps

 

Expectation:

Nisar3_1-1740570991421.png

 

Why does it say "URLs/query omit relationship to parent record" in the first image? Is there a way to enable it?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Nisar3 

This is OOB platform behavior.

1st image is embedded list and hence it shows that message

If it's related list then you can copy the query

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

7 REPLIES 7

@Nisar3 

you can see the difference easily.

Embedded list are added on form in the view using the below steps and usually look as per the 1st image you shared.

AnkurBawiskar_0-1740573247573.png

 

Related lists are added towards the end of form at bottom

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Hi @Ankur Bawiskar @Nisar3 

 

I don't think the message "URLs/query omit relationship to parent record" appears because it's a embedded list.

 

Secondly we can copy the query in the embedded list also once we have the filter condition.

 

Refer Snip-1

 

RohitSingh3_2-1740574280567.png

In Related List also we get the message. Refer Below Snip

 

RohitSingh3_1-1740574177968.png

 

If my response helped, please mark it helpful and accept the solution so that it benefits future readers.

 

Regards,
Rohit

  

 

 

 

Mark Manders
Mega Patron

There is no relation between the fields and the table (by the way: you aren't on the metric_instance table, you are on the sys_dictionary table, looking at the Collection record for the metric_instance table (which is a huge difference)).

 

The related list is a scripted related list, so no direct query is possible to that list. It's also not necessary, since you can just open the sys_dictionary table and filter on the table to get all the columns. Why would you want to do this from the related list?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark