Record producer reference variable, Variable attributes issue

[Devi16]

Hi Forum,

How can I set the fields for the reference table window on the service portal.

Here it is my issue,

I have some record producer with reference field to Location table, now I would like to display location code, street, city and zip code columns in the display window, with in the servcienow its working properly, but not in the service portal. its showing 3 time location code.

 

1st: how can I set like this sequence location code, street, city, zip

2nd : How can I give the end user search the location by locations, streets, city and zip codes.

Currently Variable attribute: ref_auto_completer=AJAXReferenceCompleter,ref_ac_order_by=u_location_code,ref_ac_columns=u_location_code;u_display_name;street;city;zip

Thanks in advance.

[Devi16]

Its working when user put something in the search, but my customer asking me, without out any keyword anything in the search, they wanted to see the list.

[Ankur Bawiskar]

Hi,

it would work only when somebody types in

without they type it won't show. This is OOB behavior

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Chander Bhusha1]

Hi Ankur,

It will work without typing as well. As it worked in my PDI with the below attributes.

we we click on field it will show the list with all the values.

Screenshot is below:

Thanks,

CB

[Ankur Bawiskar]

Hi,

Did that work when form loaded or it worked when you took control to that variable?

Not tried that yet

Regards
Ankur

[Chander Bhusha1]

Hi Ankur,

Since onload the reference list won't load. When you click on the field (when taking the control).It will show the list with all the values.

You can try that as well it will show in the format which we have defined in the attributes.

Thanks,

CB