question Location reference Variable not searching properly in ServiceNow AI Platform forum

Location reference Variable not searching properly

Vishwa Pandya19 — Fri, 06 May 2022 12:08:58 GMT

Hello,

I have a Location variable referencing to the cmn_location table.

I have selected the following location, but if I just use the keyword it is not picking up the location.

Example: I have selected 10369 Democracy Lane, some users may not know the whole address and just search for democracy. But this address does not show up.

Hope I am able to make you guys understand my problem.

Please help.

Re: Location reference Variable not searching properly

Sagar Pagar — Fri, 06 May 2022 12:18:27 GMT

Hi Vishwa,

If you want to search by field name, you need to add the attributes to the field or variable.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name,city,country,state,street,ref_ac_columns_search=true

Thanks!

Sagar Pagar

Re: Location reference Variable not searching properly

Aman Kumar S — Fri, 06 May 2022 12:24:32 GMT

Hey,

You need to ensure few things:

Ensure that the system property "glide.ui.ref_ac.startswith" is set to false.
Confirm that the reference field has similar dictionary attributes as the following: ref_ac_columns_search=true, ref_ac_order_by=column_name, ref_ac_columns=column_name1, column_name2, ref_auto_completer=AJAXTableCompleter
Create the following user preference:

Name: table_name_being_referenced.autocomplete.contains (i.e. sys_user.autocomplete.contains)System: checked
User: leave this blank
Type: true | false
Value: true

Ref article:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715718

Re: Location reference Variable not searching properly

SumanthDosapati — Fri, 06 May 2022 12:24:55 GMT

Hi @Vishwa Pandya

You can search by giving a asterisk(*) symbol in the start.

You can add a help text to the field so that users can also know that.

Mark as correct or helpful if it works.

Regards,

Sumanth

Re: Location reference Variable not searching properly

Vishwa Pandya19 — Fri, 06 May 2022 12:27:56 GMT

Thanks Aman, I'll try this too.