1C:Enterprise 8.3. Developer Guide. Appendix 4. Full-text Search Expressions

1C:Enterprise 8.3. Developer Guide. Contents


FULL-TEXT SEARCH EXPRESSIONS

You can search by several words, exact phrases or using search operators. By default synonym-based search and fuzzy search are not used. To perform searches of these types use the appropriate operators.

The following search operators can be used in the input string (both for Help/ Syntax Assistant search and for 1C:Enterprise script FullTextSearch object):

Operator         Sample Expression

 

Space

AND

AND

&

Business Success

Business AND Success

Business AND Success

Business & Success

Both "Business" and "Success" must be included

 

 

OR

OR

|

,

Business OR Success

Business OR Success

Business | Success

Business , Success

Either "Business" and "Success" must be included

 

 

NOT

NOT

~

Business NOT Success

Business NOT Success

Business ~ Success

"Business" must be included, while "Success" must not

 

 

NEAR/[±]n

NEAR/[±]n

Example 1:

drier NEAR/3 air Example 2:

drier NEAR/+3 air Example 3:

drier NEAR/-3 air

Searches for data that have the specified words in the same attribute (with account taken of morphology) separated by n words.

The sign determines where the second word should be

located with respect to the first word (+ – after the first word; - – before it).

If no sign is specified, the search returns data that contain the words separated by n words. Their order is not important. Example 1 returns data with "air" separated from "drier" by a maximum of 3 words and located before or after "drier". Example 2 returns data with "air" separated from "drier" by a maximum of 3 words and located after "drier".

Example 3 returns data with "air" separated from "drier" by a maximum of 3 words and located before "drier".

 

Operator

Sample Expression

Explanation

NEAR

NEAR

Library NEAR n.a. NEAR Dostoyevsky

Short form. The query finds data with both words in the same attribute; the words can be separated by a maximum of 8 words and located in any position.

""

"network administrator"

Finds exact terms (equivalent to "network NEAR/+1 administrator)

()

(process | production) &

(cheese | cottage cheese)

Word grouping (any number of nesting levels)

*

arch* arch* & docfl*

Searches using a wildcard – any number of "*" characters can be inserted anywhere in the word. Thus, "arch*" query can find "archive" and "archeology"

The AND or, NOT and NEAR operators must be entered in upper case only. Operators must not be used on their own (at the beginning of the search string). For example, it is not possible to select all the chapters without the specified text. All the characters in the search box except for search operators, letters and digits are ignored.

When using 1C:Enterprise script FullTextSearch object please remember the following:

Operator

Sample Expression

Explanation

*

arch* arch* & docfl*

Searches using a wildcard – only one "*" character is supported and should be added to the end of the word. Thus, "arch*" query can find "archive" and "archeology"

#

#System

System#2

Fuzzy search for words with the number of differences specified in the search box.

"#System" query (equivalent to "System#1") can return "sustem" or "syxtem".

"System#2" query can return "suxtem" or "syytem". It can only be used in full-text search

!

!red tile

Search is performed using synonyms in English, Russian and Ukrainian. "!" operator precedes the relevant word. Example: "!red tile" query finds "scarlet tile" and "coral tile" as well

The AND or, NOT and NEAR operators must be entered in upper case only. Operators must not be used on their own (at the beginning of the search string). For example, it is not possible to select all the chapters without the specified text.

To look up special characters used in texts enclose them in quotation marks. Example: "NEAR".

Leave a Reply

Your email address will not be published.

 

1C:Enterprise Developer's Community