Combine two variable results into one report column

[kshaw]

I am changing the configuration of an existing catalog item variables from a Lookup Select Box to a Reference type.

Deactivating the LSB type and adding Reference type pointing to same custom table field.

Current

vs_department                lookup select box              custom table                     retrives field text value

Future

vs_department_ref         reference                            same custom table           retrives same field text value

                                                                                                                                g_form.getDisplayBox('variable').value;

Desire

Combine the values from old variable & new varialbe into one column on a report/dashboard report to make it easy for agents to search for department without worrying about 2 different variables (and type).

Changing old variable from LSB to Ref makes old values go away for saved RITMs/Tasks.

[Community Alums]

Hi @kshaw ,

Why don't use the functional field on the report and do the concat operation of these two fields

FYI: Functional fields are also part the table.

[kshaw]

To be clear, these are variables on a cat item, not fields.