Searchable field on Department table on non display column

Chris Petrone
Tera Expert

I am looking for a way to create a field on a form that is searchable on a non display column fro mthe Department table.

 

For example, our department table has a custom column label called Epic Department [u_epic_department]. This is a String type field. We have associated the department names manually with their associated Epic departments.

 

I am wanting to create a field on a form that is dot walked to this column label [department.u_epic_department]. There is also the Department field on the form

Currently, on the form, when you fill out Department [reference field], it auto fills in the dot walked Epic Department field [string]. How can I allow our users to search by Epic Department in the field, without changing the display field on the cmn_department table to the Epic Department column label, as I don't want this changed everywhere.

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

Hi Chris,

Have you tried adding the column to the typeahead search using ref_ac_columns in the reference qualifier, with ref_ac_columns_search=true?  This changes the look of the reference search, but not the display column.

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/field-admini...