How to change the reference fields to be contains instead of startswith

Alon Grod · ‎07-17-2023

HI,

i tried to make the reference fields to work not only with a 'startwith' query but 'contains'.so far only the fields that are referencing the sys_user table work with 'contains' because i change the value of the system property -"glide.ui.ref_ac.startswith' from true to false.i want it to work on all of the reference fields of all tables not just the sys_user ones.thanks for the help

Ravi Chandra_K · ‎07-17-2023

Hello @Alon Grod

Greetings!

it should work for all tables I believe. (unless those tables have exclusive property)

have you tried log out and log in back or clearing cache?

you can also create for the tables you want from user preferences.

Go to User Preferences
Create a new with name "<table name>.autocomplete.contains" //the table for which you want.
select the "System" checkbox
Change the "type" to "true|false"
and Value to "true"

Please hit the thumb and Mark as correct based on Impact!!

Kind Regards,

Ravi Chandra.

View solution in original post

Alon Grod · ‎07-17-2023

it worked thanks.it didn't work because i had to create a preference for the table that the field is referencing and not to the table of the field itself.

Ravi Chandra_K · ‎07-17-2023

glad it worked, Thanks!

Kind Regards,

Ravi Chandra.

SatiirS · ‎10-10-2024

I tried this and it worked on the native application. However, it did not work on the portal. Is that a restriction or do I have to use another system property?