Loading

ES|QL QSTR function

Embedded
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