--- sourceDocument: Xanadu ServiceNow AI Platform Administration sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration Release : - xanadu ft:locale : - en-US ft:publication_title : - Xanadu ServiceNow AI Platform Administration ft:clusterId : - platadm bundleId : - platadm workflow : - Platform --- # Change the query mode of an indexed table # Change the query mode of an indexed table {#ariaid-title1} * Release version: Xanadu * * Updated August 1, 2024 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Set the query mode to specify whether searches on an indexed table must match all or only some of the search terms. ## Before you begin To change the query mode of an indexed table, a text index must be present for the table. Make sure that text indexing is enabled for the table before changing the query mode. See [Configure a table for indexing and searching](https://servicenow-prod.fluidtopics.net/ikx52T2SvdSyrAWcJbB0lA#configure-single-table-for-indexing "Enable Zing text indexing for a table to allow users to search its records for string values. Configure the table's text indexing attributes, stop words, and synonym dictionaries to control search behavior."). Role required: ts_admin or admin ## About this task Once a table is indexed, the data within the table can be searched through the global search bar. Change the query mode for the indexed table to allow global search to match all or only some of the searched terms. Enable a partial match rule to return results that partially match the searched terms. ## Procedure 1. Navigate to AllSystem DefinitionText Indexes. 2. Select the table you want to configure from the list of indexed tables. 3. Use the combo box to select a Default query mode. | Option | Description | | Default | The default query mode for a table is an AND query. | | AND | Matches all search terms. | | OR | Matches one or more search terms. | | AND_OR | Matches all search terms. If no results are found, matches one or more search terms. | |-|-| {#configure-table-query-mode__choicetable_rjr_4mz_yy} 4. To enable partial matching of search terms, configure the partial match rule in the Partial Match Rule field. Partial match rules return results that partially match the search terms. Use a partial match rule if queries often include many keywords (if, for example, users cut and paste phrases into the global search bar). {#configure-table-query-mode__table_wdx_fpz_yy__entry__3} | Input type | Example | Description | |-|-|-| | Integer | 3 | Indicates the minimum number of search terms to be matched. | | Negative integer | -2 | Indicates that the number of search terms, minus this number, should be matched. | | Percentage | 75% | Indicates the minimum percentage of search terms to be matched. The minimum number of search terms is the number computed from the percentage rounded down. | | Negative percentage | -25% | Indicates that the number of search terms, minus this percentage, should be matched. The minimum number of search terms is the number computed from the percentage rounded down and subtracted from the total number of search terms. | | Combination | 3\<70% | A positive integer, followed by a less than symbol, followed by any of the previously mentioned input types. Indicates that if the number of search terms is equal to or less than the integer, all search terms are required. If the number of search terms is greater than the integer, the specification applies. In this example: if there are 1--3 search terms, all are required. If there are 4 or more search terms, only 70% are required. | | Multiple combinations | 3\<-25%, 9\<-5 | Multiple conditional specifications separated by commas. In this example: if there are 1--3 search terms, all are required. If there are 4--9 search terms, all but 25% are required. If there are more than 9 search terms, all but 5 are required. | [Table 1. Partial match rules] {#configure-table-query-mode__table_wdx_fpz_yy} **Related concepts** * [Zing indexes punctuation as part of some words](https://servicenow-prod.fluidtopics.net/w7uB09y~FMmb2pFvBd6hwg "Zing indexes some punctuation marks as part of some words to improve search results for common search terms.") * [Zing indexes some HTML elements](https://servicenow-prod.fluidtopics.net/ka_LSPsauIUfAhCQ_t7bIA "Zing indexes the contents of certain HTML elements to improve document search results. This indexing is addition to the normal indexing by word.") **Related tasks** * [Configure a table for indexing and searching](https://servicenow-prod.fluidtopics.net/ikx52T2SvdSyrAWcJbB0lA#configure-single-table-for-indexing "Enable Zing text indexing for a table to allow users to search its records for string values. Configure the table's text indexing attributes, stop words, and synonym dictionaries to control search behavior.") * [Configure a text index group to search across multiple tables](https://servicenow-prod.fluidtopics.net/_Tqphpv96UK1ogrveyz4mg "Update tables to the V4 indexing format and include them in a text index group to facilitate searching across multiple tables.") * [Regenerate a text index for a table](https://servicenow-prod.fluidtopics.net/EhFB579yIrCuwIp2hhyGHA "You can regenerate a table text index when you change table stop words or display values.") * [Remove an index](https://servicenow-prod.fluidtopics.net/xgsKH0hNHvRqe9szc3ir2A "You can remove the index for a table if you no longer want the search engine to return results for that table. This procedure also removes the index for all tables that extend the specified table.") * [Remove an index for a specific field](https://servicenow-prod.fluidtopics.net/CSQJCQNy12hVM~sn8G3m3g "You can remove the index for a specific field in a table if you no longer want the search engine to return results for that field.") * [Remove the text index for a child table](https://servicenow-prod.fluidtopics.net/CO6UXxVULBBlub6YaQDqtg "You can remove the text index for a child table if you no longer want the search engine to return results for that child table.") * [Enable indexing of text in multi-row variable sets](https://servicenow-prod.fluidtopics.net/h3Rx9FN5RISMSrF0Tjb9sA "Make text from multi-row Service Catalog variable sets searchable in global search.") * [Configure tables to use the Japanese tokenizer](https://servicenow-prod.fluidtopics.net/E0EWdE3uDM7mAVWTgDS8Cw "Improve search results in Japanese language searches by configuring individual tables to use the Japanese tokenizer.") **Related reference** * [Zing index and search dictionary attributes](https://servicenow-prod.fluidtopics.net/cov1YoVQP8FsNSEuqNnsAg "The following dictionary attributes either affect the way Zing indexes tables or ranks search results.") * [Text indexing statistics and status](https://servicenow-prod.fluidtopics.net/t0_oxn~6xib1FACmS31utg "To view text indexing statistics and status, navigate to All > System Definition > Text Indexes .") *[\>]: and then