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,
I'm not quite clear what it is you are trying to do. The columns that appear in the reference lookup (e.g. project number, short description, etc.) are static rather than dynamic.
If you configure the ref_ac attributes per Pradeep's link, you determine which columns are displayed. From there on, they are always visible when filling in data in the field.
Auto-Complete for Reference Fields - ServiceNow Wiki
please refer to the screen shot below, sry for the confusion
Regards
