Text-based property values
The objectPath and customMetadataContent properties and tokenized content properties match text in the object path or custom metadata.
Text-based property values are text strings consisting of one or more
UTF-8 characters. The string is interpreted as one or more search terms, where each search term is a sequence of either alphabetic or numeric characters. All other characters, except wildcards, are treated as term separators.
For example, the string product123
contains two search terms — product
and 123
. A query based on this string finds objects for which the specified property contains at least one of product
and 123
.
Search terms match only complete alphabetic or numeric strings in paths or custom metadata. For example, the text strings AnnualReport
, 2012
, and AnnualReport_2012
match the object named AnnualReport_2012.pdf. A query expression with a text string such as Annual
or 201
does not match this object.
Similarly, to query for objects with a path or custom metadata that contains the word product
, you need to use the complete word product
as the text string. A query expression with a text string such as prod
does not match objects with a path or custom metadata containing product
.
Common words such as a
and is
are indexed and are valid search terms. For example, a query containing the text string A3534
matches all objects with paths and custom metadata that contain the word a
.
Search terms are not case sensitive. Therefore, the strings AnnualReport
, Annualreport
, and annualreport
are equivalent.
Common words such as a
and is
are valid search terms. For example, a query containing the text string A3534
matches all objects with paths and custom metadata that contain the word a
. To prevent such a match, use a phrase as described below.
To specify a negative number as a criterion, enclose the value in double quotation marks, for example, "-3121"
.
To specify a phrase as a criterion, put the text string in double quotation marks. A phrase matches paths and custom metadata that contain each of the alphabetic or numeric search terms within the quotation marks in the specified order, but any special characters or white space between the individual strings is ignored. For example, the phrase "product 123"
matches custom metadata that contains any of these strings:
product 123 product123 product_123