Show 'Alias' Column from Business Application to CI Search Pop-up Reference Field

[TheKatherine]

I need some assistance with trying to accomplish the following.

On Problem ticket, we have the 'Configuration Item' field shown.

When a user starts to type text into the field for searching, currently the pop-up box only shows the columns of name and class (see attached image 1 to see the current columns shown).

We would like to add the column 'alias' to this pop-up box when the user starts typing a business application (see attached image 2 to show we have business application CI's with data in the alias field)

I did the following steps already, however the 'alias' column is not showing:

1. opened the problem form
2. right mouse click on the configuration item field > chose configure dictionary
3. in the attributes field, I have the following entered:
   

   • encode_utf8=false,ref_ac_columns=sys_class_name;u_alias,ref_ac_columns_search=true, ref_ac_order_by=sys_class_name,ref_auto_completer=AJAXTableCompleter,ref_contributions=task_show_ci_map;show_related_records

What am I missing or doing wrong? Any help on this would be appreciated.

thank you

Katherine

[Brad Bowman]

One option would be to create the field on the cmdb_ci table, or use an existing field that is otherwise unused, then run a script to copy all of the existing values from one to the other, and a Business Rule to keep future changes in sync if the field on the business_app table must be retained.  If you will only ever use records from the business_app table for problems, then you can create a new field on the problem table that references this table instead of cmdb_ci.  That's a bit less future-proof than the first alternative.  I'll let you know if anything else comes to mind later.