Query language for full-text search

You can search by multiple words, use search operators, and search by exact phrases.

You can use the following operators in the search string:

 Operator  Example  Details
AND
&
 entry AND document
 entry & document
Find items containing both entry and document (in any word form).
OR
|
,
 entry OR document
 entry | document
 entry , document
Find items containing at least one of the words, either entry or document.
NOT
~
 closing NOT month
 closing ~ month
Find items containing closing, but not month.
 "~" cannot be used at the beginning of the string.
NEAR/[±]n

 Example 1:
 sale NEAR/3 product

 Example 2:
 sale NEAR/+3 product

 Example 3:
 sale NEAR/-3 product

Find items that have the specified words (in any word form) in a single attribute, separated by n or less words.
The sign determines the relative position of the second word ("+" if the second word comes after the first one; "-" if the second word comes before the first one).
If the sign is not specified, the search will return items that contain both words separated by n or less words, their order does not matter.
Example 1 will return items where product comes before or after sale, separated by a maximum of 3 words.
Example 2 will return items where product comes after sale, separated by a maximum of 3 words.
Example 3 will return items where product comes before sale, separated by a maximum of 3 words.
NEAR  posting NEAR document Simplified distance operator.
Find items where both words are present in a single attribute, separated by a maximum of 8 words, their order does not matter.
" "  "document posting" Find the exact word sequence, each word can have any word form (equivalent to: document NEAR/+1 posting).
()  (post | create) &
 (account , document)
Use to specify the order of operators (the number of nesting levels is not limited).

*

 docu* Use a wildcard (replacing the end of the word).
More than 1 significant character must be entered.
The "docu*" query will find "document", "documenting", "documentation", and so on.

#

 #System
 System#2

Fuzzy search for words with the specified number of differences from the specified search string (1 if the number is omitted).
Examples:
The query "#System" will find "systwm" and "sydtem".
The query "System#2" will find "syttwm" and"suttem".

!

!red Find synonyms (applicable to English, Russian and Ukrainian). "!" should precede the word whose synonyms you want to find. For example, search for "!red tile" will find "scarlet tile" and "coral tile" as well.

 

Restriction. If a search query contains a wildcard (the * operator), the search can return a lot of results. The total number of results cannot exceed 1000.

1C:Enterprise Developer's Community