About Variables (Reference Type)

[k-tsumori]

What are the variables (reference types) for catalog items?
When I check the portal, it returns search results that start with the characters I entered, but can I make the search results include the characters I entered?
I would appreciate it if you could tell me if it is possible to achieve results like a search for “*xx” with the input “xx” without wildcards.

[Dr Atul G- LNG]

Hi @k-tsumori 

Yes, you can search, but the results will differ.

When we use *, it means the value can appear anywhere in the field, and it will display results matching that combination.

However, if you search without *, it uses the "starts with" operator by default.

[Ankur Bawiskar · Accepted solution]

@k-tsumori 

you can use this but remember it would be impacting other places as well

1. Ensure that the system property "glide.ui.ref_ac.startswith" is set to false.

2. Confirm that the reference field has 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

4. After the user preference has been created log out and back into the instance for it to take effect

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@k-tsumori 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@k-tsumori 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.