Handling query method via system property "glide.ts.query.and_or_limit" for global text search | General Information

Overview

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

Details

By default, this system property has value 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 "Pizza" keyword in their short_description field.
• 5 other incidents contain "Burgers" keyword in their short_description field.
• 5 other incidents contain "Pizza" and "Burgers" keyword in their short_description field.

So, if we are in incident table list view and under the header we perform keyword search, the number of results depend 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).

Additional Information

Change the query mode of an indexed table: https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/search-administration/task/configure-table-query-mode.html

Apply configuration to search: https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/contextual-search/task/t_ApplyConfigurationToSearch.html