Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home Paris Now Platform Administration Now Platform administration Search administration Zing text indexing and search engine Zing indexes words Change the query mode of an indexed table

    Change the query mode of an indexed table

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    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 begin

    Role required: admin

    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 Enable text indexing for a table.

    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 System Definition > Text 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.
      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.
    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).
      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 tasks
    • Enable text indexing for a table
    • Configure a single table for indexing and searching
    • Configure multiple tables for indexing and searching
    • Regenerate a text index for a table
    • Regenerate a corrupt index
    • Remove an index
    • Remove an index for a specific field
    • Remove an index for a child table
    • Configure tables to use the Japanese tokenizer
    Related concepts
    • Zing indexes punctuation as part of some words
    • Zing indexes some HTML elements
    Related reference
    • Zing index and search dictionary attributes
    • Text indexing statistics and status

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Change the query mode of an indexed table

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      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 begin

      Role required: admin

      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 Enable text indexing for a table.

      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 System Definition > Text 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.
        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.
      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).
        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 tasks
      • Enable text indexing for a table
      • Configure a single table for indexing and searching
      • Configure multiple tables for indexing and searching
      • Regenerate a text index for a table
      • Regenerate a corrupt index
      • Remove an index
      • Remove an index for a specific field
      • Remove an index for a child table
      • Configure tables to use the Japanese tokenizer
      Related concepts
      • Zing indexes punctuation as part of some words
      • Zing indexes some HTML elements
      Related reference
      • Zing index and search dictionary attributes
      • Text indexing statistics and status

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login