Skip to main content

DQL Search

Dashboards Query Language (DQL) is a simple text-based query language used to filter data in DT Cloud Observability.

When running queries, understanding whether your fields are analyzed (text type) or non-analyzed (keyword type) is crucial because it significantly impacts search behavior. In analyzed fields, text undergoes tokenization and filtering, while non-analyzed fields store exact values.

Search for Terms​

By default, DQL searches in the field set as the default field on the index. If the default field is not set, DQL searches all fields. For example, the following query searches for documents containing the words rises or wind in any of their fields:

rises wind

Reserved Characters​

The following is a list of reserved characters in DQL:

\, (, ), :, <, >, ", *

Use a backslash (\) to escape reserved characters. For example, to search for an expression 2*3, specify the query as 2\*3:

2\*3

Search in a Field​

To search for text in a particular field, specify the field name before the colon:

title: rises wind

Wildcards​

DQL supports wildcards (* only) in both search terms and field names, for example:

t*le: *wind and rise*

Ranges​

DQL supports numeric inequalities using the >, <, >=, and <= operators, for example:

page_views > 100 and page_views <= 300

Boolean Operators​

DQL supports the and, or, and not Boolean operators. DQL is not case sensitive, so AND and and are the same. For example, the following query is a conjunction of two Boolean clauses:

title: wind and description: epic