Fulltext Query Syntax
The following properties are searched with an accommodation:
- ST Object Code
Any text with one or more terms is considered a valid starting point for query execution. OpenBooking Fulltext will match accommodations containing any or all of the terms in Name and City, including any variations found during analysis of the text.
You can embed operators in a query string to build a riche set of criteria against which matching documents are found.
The AND operator is a plus sign. For example,
hotel+luxurywill search for accommodations containing both
The OR operator is a vertical bar or pipe character. For example,
hotel | luxurywill search for documents containing either
The NOT operator is a minus sign. For example,
–luxurywill search for accommodations that have the
hotelterm and/or do not have
The suffix operator is an asterisk. For example,
lux*will search for accommodations that have a term that starts with
lux, ignoring case.
The phrase operator encloses a phrase in quotation marks. For example, while
City Motel(without quotes) would search for documents containing
Motelanywhere in any order,
"City Motel"(with quotes) will only match documents that contain that whole phrase together and in that order (text analysis still applies).
The precedence operator encloses the string in parentheses. For example,
motel+(engelberg | luxury)will search for documents containing the motel term and either
In order to use the above symbols as actual part of the search text, they should be escaped by prefixing them with a backslash. For example,
luxury\\+hotelwill result in the term
luxury+hotel. In order to make things simple for the more typical cases, there are two exceptions to this rule where escaping is not needed:
- The NOT operator
-only needs to be escaped if it's the first character after whitespace, not if it's in the middle of a term. For example,
wi-fiis a single term
- The suffix operator
*needs to be escaped only if it's the last character before whitespace, not if it's in the middle of a term. For example,
wi*fiis treated as a single token.