ES|QL QSTR function
query- Query string in Lucene query string format.
options-
(Optional) Additional options for Query String as function named parameters. See query string query for more information.
Performs a query string query. Returns true if the provided query string matches the row.
| query | options | result |
|---|---|---|
| keyword | named parameters | boolean |
| text | named parameters | boolean |
max_determinized_states- (integer) Maximum number of automaton states required for the query. Default is 10000.
fuzziness- (keyword) Maximum edit distance allowed for matching.
auto_generate_synonyms_phrase_query- (boolean) If true, match phrase queries are automatically created for multi-term synonyms. Defaults to true.
phrase_slop- (integer) Maximum number of positions allowed between matching tokens for phrases. Defaults to 0 (which means exact matches are required).
default_field- (keyword) Default field to search if no field is provided in the query string. Supports wildcards (*).
allow_leading_wildcard- (boolean) If true, the wildcard characters * and ? are allowed as the first character of the query string. Defaults to true.
minimum_should_match- (string) Minimum number of clauses that must match for a document to be returned.
fuzzy_transpositions- (boolean) If true, edits for fuzzy matching include transpositions of two adjacent characters (ab → ba). Defaults to true.
fuzzy_prefix_length- (integer) Number of beginning characters left unchanged for fuzzy matching. Defaults to 0.
time_zone- (keyword) Coordinated Universal Time (UTC) offset or IANA time zone used to convert date values in the query string to UTC.
lenient- (boolean) If false, format-based errors, such as providing a text query value for a numeric field, are returned. Defaults to false.
rewrite- (keyword) Method used to rewrite the query.
default_operator- (keyword) Default boolean logic used to interpret text in the query string if no operators are specified.
analyzer- (keyword) Analyzer used to convert the text in the query value into token. Defaults to the index-time analyzer mapped for the default_field.
fuzzy_max_expansions- (integer) Maximum number of terms to which the query expands for fuzzy matching. Defaults to 50.
quote_analyzer- (keyword) Analyzer used to convert quoted text in the query string into tokens. Defaults to the search_quote_analyzer mapped for the default_field.
allow_wildcard- (boolean) If true, the query attempts to analyze wildcard terms in the query string. Defaults to false.
boost- (float) Floating point number used to decrease or increase the relevance scores of the query.
quote_field_suffix- (keyword) Suffix appended to quoted text in the query string.
enable_position_increments- (boolean) If true, enable position increments in queries constructed from a query_string search. Defaults to true.
fields-
(keyword) Array of fields to search. Supports wildcards (*).
FROM books
| WHERE QSTR("author: Faulkner")
| book_no:keyword | author:text |
|---|---|
| 2378 | [Carol Faulkner, Holly Byers Ochoa, Lucretia Mott] |
| 2713 | William Faulkner |
| 2847 | Colleen Faulkner |
| 2883 | William Faulkner |
| 3293 | Danny Faulkner |
FROM books
| WHERE QSTR("title: Hobbjt~", {"fuzziness": 2})
| book_no:keyword | title:text |
|---|---|
| 4289 | Poems from the Hobbit |
| 6405 | The Hobbit or There and Back Again |
| 7480 | The Hobbit |