Show incident number and short description in reference variable

jcwarren
Kilo Guru

We would like to be able to have an incident number and the short description visible in a reference variable on a service catalog form when a user selects the relevant incident number. We've also been unable to get the short description to show in the drop-down list using variable attributes.

 

Current variable view after selecting the relevant incident number.

jcwarren_0-1674751681240.png

Variable attributes: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=number,short_description;ref_ac_order_by=number,ref_ac_columns_search=true

 

Any guidance would be appreciated.

2 ACCEPTED SOLUTIONS

Thank you Soeren. I'd already corrected my typo. The desired result was to concatenate the incident number and short description. We solve the issue with an additional variable and a client script that populates the field.

 

Thanks again. 

View solution in original post

Thank you Basheer. I'd already corrected my typo. The desired result was to concatenate the incident number and short description. We solve the issue with an additional variable and a client script that populates the field.

 

Thanks again. 

View solution in original post

4 REPLIES 4

Soeren Maucher
Mega Sage

Hello @jcwarren

 

in your attributes there is a small typo. Instead of ";" it should be "," in the highlighted section and the number should be removed, since it is already shown per default. 

SoerenMaucher_2-1674754372267.png

Just try the following and your result should look accordingly: 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=short_description,ref_ac_order_by=number,ref_ac_columns_search=true

 

SoerenMaucher_0-1674754193757.png

Once a record is selected, as far as I know, only one field can be displayed (in this case "number"). 

I hope this helped. 

Greetings, 
Sören

 

Thank you Soeren. I'd already corrected my typo. The desired result was to concatenate the incident number and short description. We solve the issue with an additional variable and a client script that populates the field.

 

Thanks again. 

Basheer
Mega Sage

Hi @jcwarren 

It should be ; after number and , after short_description not ;

number;short_description

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=number;short_description,ref_ac_order_by=number,ref_ac_columns_search=true

 

Please hit like button if my suggestion has helped you in any way.
Please mark correct if my response has solved your query.

Cheers,
Mohammed Basheer Ahmed.

Thank you Basheer. I'd already corrected my typo. The desired result was to concatenate the incident number and short description. We solve the issue with an additional variable and a client script that populates the field.

 

Thanks again.