Location reference Variable not searching properly

[Vishwa Pandya19]

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.

[Sagar Pagar]

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

[Aman Kumar S]

Hey,

You need to ensure few things:

1. Ensure that the system property "glide.ui.ref_ac.startswith" is set to false.
   
   
2. 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
   
   
3. 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

[Vishwa Pandya19]

Thanks Aman, I'll try this too.

[SumanthDosapati · Accepted solution]

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