Searchable field on Department table on non display column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2025 07:55 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2025 09:46 AM
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.