Service Portal Widget - How can I display multiple columns for a referenced field

[Peter Bishop]

In the Service Portal, I have a page that's used to add records to a table. On the page is a widget which shows the form from a table and one of the fields in this table is a reference field.

When the user accesses the reference field (to select a value), only the "display=true" column of that referenced table is listed. I have tried adding the collection attribute "ref_ac_columns=column1;column2" but this hasn't made any difference.

Can anyone advise how I can achieve this functionality?

[Pranesh072]

No no that is wrong.

goto the field and right click on it. You have to update the field's dictionary.

Also your "ref_ac_columns" value only shows one column but your screenshot is displaying two - first one is display true value and second one i added by earlier configuration

[Peter Bishop]

Ah, well *that* solved the problem! Amazing how things work when you do them properly.

Many thanks.

[Manisha Kumari]

Add the below Variable attributes in your field, and change the bold value based on your reference table backend field name.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_number,ref_ac_columns_search=true,

Regards,

Manisha

[Peter Bishop]

Sorry, that doesn't seem to make any difference

[Manisha Kumari]

Once it was not working for me because of cache issue.

try cache.do in navigation