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.

[Ankur Bawiskar]

Got it.

So when somebody clicks on that variable it starts showing the fields since control is moved to it

Regards
Ankur

[Chander Bhusha1]

Hi Rdevi,

You can try this:

in the variable attribute put this:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;street;city;zip,ref_ac_columns_search=true,ref_ac_display_value=false

Specify the highlighted fields which you wan't to display.

The fields which will display on load is :

And put in the order in which you want. and in the search it will search with anything the screenshot is :

See i search with the city so it displayed the city which i entered.

Mark helpful and correct if it helps.

Thanks,

CB

[Devi16]

Hi,

I tried as you mentioned like this

City displaying 3 times

[Chander Bhusha1]

Hi Rdevi,

it was working fine for me as shown in the screenshot.

 I found one HI ticket for the location reference field also has the same issue.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0721858

Mark helpful and correct if it helps

Thank,

Cb