Variable attributes in Service Portal

mp27 · ‎03-14-2017

Hi,

I noticed that variable attributes don't work properly in Service Portal.

Setting "ref_ac_columns" won't display the expected columns in the reference field of a catalog item (the columns remain searchable though).

This can be quite critical as only the "display" field seem to be displayed.

For example, it would not be possible to display the full address of a location, except by creating a field on the table for that only purpose, which is not ideal.

Does anyone have a more convenient workaround?

Thank you,

Max

matthijsoomen · ‎07-11-2017

Hi,

I do not know if you have solved it already, but for others this could still be useful.

To show extra columns in a reference field on the portal you will have to add 2 additional attributes next to 'ref_ac_columns' .

There additional attributes are: 'ref_auto_completer=AJAXTableCompleter' and 'ref_ac_order_by=[display value]'.

So for instance, if you want to also show the email-address for a user in the portal. Your attributes field should look like this:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_order_by=name

Hope this is helpful.

Matthijs

View solution in original post

Palash Sarkar1 · ‎08-28-2019

Hi

You saved my time, thanks...

Just for information to others.

I tried to display sc_req_item table variables field value. For that case attributes field should look like this:

ref_ac_columns=sys_created_on;variables.598a6790db47378078ca9e04db96191e;variables.633ca17adbc337c0af611db41b9619b3,ref_ac_order_by=number,ref_auto_completer=AJAXTableCompleter

Duncan Pederse1 · ‎12-16-2019

@Palash Sarkar thank you for that!!

Weird · ‎01-20-2022

Did this work? I got intrigued by the thought based on another question, but when I tried a similar approach to you I didn't get it to work.

ZapellaT · ‎10-13-2022

THANK YOU (from the future)!!!!