Record producer reference variable, Variable attributes issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2020 11:39 AM
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.
- Labels:
-
Service Portal Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2020 11:53 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2020 01:30 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2020 08:46 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2020 07:25 PM
Hello,
See below docs,
If answer is helpful please mark correct!
Thanks,
Pratiksha