How to get full query from a defined related list

[Aaron Dalton]

I'm setting up a related list using a defined Relationship that adds specific queries to the list. These queries don't appear in the breadcrumbs of the related list and also don't show up using a UI Action and calling g_list.getQuery(). 

Is there a way to access the relationship's queries from a related list using a UI action?

[Claude DAmico]

This seems like it would be helpful to you.

https://www.servicenow.com/community/developer-blog/query-business-rules-a-definitive-guide/ba-p/227... 

[Allen Andreas · Accepted solution]

Hi,

You may have to go to the DOM on this one (as much as I don't like that), because the query isn't actually associated with the related list in the view that we can see and seems to be added another way.

I was able to get the query by doing something like this showing all pieces:

Find list back-end name by right-clicking any column header and choose Configure > List Control

Copy list name: 

Use script like this in your UI Action (needs to be client side) AND add _table to the end of your list name like so:

function findFilter() {
    var list = document.getElementById('incident.REL:86e358a1970de5509b483a300153af03_table').getAttribute('glide_list_query');
    alert("Filter is: " + list);
}

Then finally...when it's all said and done...you get:

[Aaron Dalton]

This is exactly what I needed! For some reason I couldn't get it to work in my UI Action itself even though "Client" was checked and "Isolate Script" was FALSE. However, since I'm using a UI Page with this as well, I just moved this script into there. Works perfectly. Thanks so much!

[Allen Andreas]

Awesome, glad it was helpful and provided a good solution for you to use.

Take care! 🙂