The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Record producer reference variable, Variable attributes issue

Devi16
Tera Contributor

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.

 

find_real_file.png 

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.

 

 

18 REPLIES 18

Mike Patel
Tera Sage

try changing it to

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_location_code;u_display_name;street;city;zip,ref_ac_columns_search=true,ref_ac_order_by=u_location_code

or

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_display_name;street;city;zip,ref_ac_columns_search=true,ref_ac_order_by=u_location_code

Devi16
Tera Contributor

Thanks for replay Mike, 

No luck with that change "ref_auto_completer=AJAXReferenceCompleter,ref_ac_columns_search=true,ref_ac_order_by=u_location_code,ref_ac_columns=u_location_code;u_display_name;street;city;zip" 

 

and if I did not put any value the search, list displaying based on city, but I would like to change it to be based on location code, my customer dont want be see city name, because for the city we will have many records, if we go with location code, end user will see only unique records. that'y this change. and needs to maintain location code, street, city, zip as rows.

find_real_file.png

This should have worked. Can you clear the cache after making the change and reload page.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_location_code;u_display_name;street;city;zip,ref_ac_columns_search=true,ref_ac_order_by=u_location_code

Pratiksha Kalam
Kilo Sage

Hello,

See below docs,

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

 

If answer is helpful please mark correct!

Thanks,

Pratiksha