How can I set reference filters of search condition in List of records?

jimin han
Kilo Contributor

Hi

How can I set reference filters of search condition  in List of records?

Even if it's the same table, it's hard to fix it because I want a different filter for each screen

This is a just example. In this example, I want to set reference filters of Publisher in only this Software Models list page.

find_real_file.png

 

5 REPLIES 5

Tony Chatfield1
Kilo Patron

Hi, my PDI is San Diego and I do not see a 'Publisher' field on the Software Model or parent Product Model tables, is this from a plugin or addon application?
If this is a field on Software Model table you should be able to create a refqualifer, or a dictionary override for the parent tables field.
If this is not a field from the table shown in your screenshots then you may need to clarify your configuration, and the location of this field so that the forum is in a better position to understand your issue and context.

Thank you answering my queston.

 'Publisher' field is an example that I made.

I want to really know if I can set search filters of reference field.

For example, I made a table named T1, And I use a reference field of this table(T1) in another table named T2.

I want to use this reference field of which is specific state; like active state

So, when I search this reference field of the list, I watch only reference list of this state.

(Simply, when I watch list of records(Table T1), I want to watch all records of the table.

In other words, I want to apply filters in only seach list (Like the attached pop-up page)

Hi, reference qualifiers will allow you to filter the results for any table that is being directly referenced IE if fieldX exists as a reference to T2 on T1, you can use a ref qualifier on the T1 field to limit the records available from T2 when you select the fieldX lookup.

Reference qualifiers (servicenow.com)

Dictionary overrides (servicenow.com)

There are many OOB examples of simple and advance refqualifiers OOB and you can see these

/sys_dictionary_list.do?sysparm_query=reference_qualISNOTEMPTY&sysparm_view=easily from the dictionary

I would also recommend reviewing encoded queries as they are used commonly in refqualifiers, (you can also use javascript to call script-include functions that return encoded queries\filters)

Encoded query strings (servicenow.com)

Thank you for answering my question in detail.

I already applied ref qualifier in dictionary

But the filter don't work in search list of the field (It work in only edit,create record page)

 

find_real_file.png