How can I set reference filters of search condition in List of records?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2022 05:52 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2022 09:03 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2022 09:27 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2022 10:30 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2022 12:42 AM