Hi
Is it possible to filter the search result in a reference field, say for example if a project field is referenced in a table like
can i filter the results when i click on the search icon as shown in the screen shot above?
Regards
Hi John,
Yes, you can do that quite easily! Reference fields can use what's called "Reference qualifier" to filter records on the table they reference. By default, you get all the records. If you want to filter them, you can do that quite easily using a reference qualifier. They range from simple (no scripting required) to more advanced (scripted.)
Go to the dictionary entry for that field and note the "Reference specification" section.
Here's an example of a reference qualifier on a table to simply take the Active records of the User table.
Reference: Reference Qualifiers - ServiceNow Wiki
Hi John,
Yes, you can do that quite easily! Reference fields can use what's called "Reference qualifier" to filter records on the table they reference. By default, you get all the records. If you want to filter them, you can do that quite easily using a reference qualifier. They range from simple (no scripting required) to more advanced (scripted.)
Go to the dictionary entry for that field and note the "Reference specification" section.
Here's an example of a reference qualifier on a table to simply take the Active records of the User table.
Reference: Reference Qualifiers - ServiceNow Wiki
