How to handle query method via a system property called "glide.ts.query.and_or_limit" for global text searches

By default, this system property has a value of 0 in an OOB instance. And it's functionality is that if the "AND" query result count is less than or equal to the number value defined in the system property, it will run an "OR" query.

Example

Let's consider keyword text searching ("Pizza", "Burgers") on an incident table.

• 5 incidents contain the "Pizza" keyword in their short_description field.
• 5 other incidents contain the "Burgers" keyword in their short_description field.
• 5 other incidents contain the "Pizza" and "Burgers" keywords in their short_description field.

So, if we are in the incident table list view and under the header we perform a keyword search, the number of results depends on what value this system property has at that time.

Hence, the test cases conducted were the following:

Please note that this functionality works only on indexed tables and when the "default query mode" field for the respective tables has value as "AND_OR" instead of "Default" (that does only AND query).

Change the query mode of an indexed table

Configure search resource context properties