Contents Now Platform Administration Previous Topic Next Topic Change the query mode of an indexed table ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Other Share Change the query mode of an indexed table Set the query mode to specify whether searches on an indexed table must match all or only some of the search terms. Before you beginRole required: adminTo 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 Enable text indexing for a table. About this taskOnce 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 Navigate to System Definition > Text Indexes. Select the table you want to configure from the list of indexed tables. Use the combo box to select a Default query mode. OptionDescription 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. 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). Table 1. Partial match rules 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. Related TasksEnable text indexing for a tableRegenerate a text index for a tableRemove an indexRemove an index for a specific fieldConfigure tables to use the Japanese tokenizerRelated ConceptsZing indexes punctuation as part of some wordsZing indexes some HTML elementsRegenerate a corrupt indexRelated ReferenceText indexing statistics and status On this page Send Feedback Previous Topic Next Topic

Change the query mode of an indexed table Set the query mode to specify whether searches on an indexed table must match all or only some of the search terms. Before you beginRole required: adminTo 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 Enable text indexing for a table. About this taskOnce 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 Navigate to System Definition > Text Indexes. Select the table you want to configure from the list of indexed tables. Use the combo box to select a Default query mode. OptionDescription 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. 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). Table 1. Partial match rules 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. Related TasksEnable text indexing for a tableRegenerate a text index for a tableRemove an indexRemove an index for a specific fieldConfigure tables to use the Japanese tokenizerRelated ConceptsZing indexes punctuation as part of some wordsZing indexes some HTML elementsRegenerate a corrupt indexRelated ReferenceText indexing statistics and status

Change the query mode of an indexed table Set the query mode to specify whether searches on an indexed table must match all or only some of the search terms. Before you beginRole required: adminTo 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 Enable text indexing for a table. About this taskOnce 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 Navigate to System Definition > Text Indexes. Select the table you want to configure from the list of indexed tables. Use the combo box to select a Default query mode. OptionDescription 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. 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). Table 1. Partial match rules 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. Related TasksEnable text indexing for a tableRegenerate a text index for a tableRemove an indexRemove an index for a specific fieldConfigure tables to use the Japanese tokenizerRelated ConceptsZing indexes punctuation as part of some wordsZing indexes some HTML elementsRegenerate a corrupt indexRelated ReferenceText indexing statistics and status