Is there anyway to get a reference field to show multiple fields when typing in a value?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-09-2018 07:24 AM
I have a reference field where someone starts typing a serial number and it's pointing to the asset table. Is there anyway to get it to display not only the Serial Number but also the Assigned to? It won't let me put the picture in as it shows it's broken but i've attached it. TIA

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-09-2018 08:00 AM
Yes, the ref_ac_columns attribute.
See the attributes on the Configuration item column on the task table as an example.
Also see this documentation: Auto-complete for reference fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-09-2018 08:06 AM
I thought that I have ref_ac_columns=serial;assigned_to and it's pointing to the asset table but it doesn't change the display to include the assigned to.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-09-2018 09:25 AM
Are you talking about the display value after a value is selected? This is only for auto-complete before a value is selected.
You can only have one column as the display value. You would have to make a custom column that is a calculated field concatenation of serial number and assigned to, then make that column the new display column for the cmdb_ci table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-09-2018 09:31 AM
Also, it's serial_number not serial. That could be a problem possibly. Another thing to check for is dictionary overrides. If you are adding the attribute to the task cmdb_ci field and using the change_request form, for example there could be a dictionary override that overrides the attributes for change requests.