Back to Elasticsearch

Kql

docs/reference/query-languages/esql/_snippets/functions/examples/kql.md

9.4.0690 B
Original Source

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Examples

Use KQL to filter by a specific field value

esql
FROM books
| WHERE KQL("author: Faulkner")
book_no:keywordauthor:text
2378[Carol Faulkner, Holly Byers Ochoa, Lucretia Mott]
2713William Faulkner
2847Colleen Faulkner
2883William Faulkner
3293Danny Faulkner
{applies_to}
stack: ga 9.3.0

Use KQL with additional options for case-insensitive matching and custom settings

esql
FROM employees
| WHERE KQL("mary", {"case_insensitive": true, "default_field": "first_name", "boost": 1.5})