# Directual Query Language (DQL)

Data structure can contain millions of objects. You can use Directual Query Language (DQL) for searching and filtering them.&#x20;

![Example of applying DQL](https://3071851461-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4Nnmtk9_gFGWOddsf6%2F-M5HVcNVXwhlgHd4QjZC%2F-M5HZO6ac2g_viBICsY-%2FDQL.gif?alt=media\&token=713ed477-a2bf-4f40-8cf8-079e97e9674e)

Here are some examples of DQL-requests:

Request `42` is a synonym to `id = "42"` — it finds the object with **ID** = *42.*

`(title like "sun" AND year < 1950) OR is_good = "true"`— finds objects of two groups. First: with **titles** similar to *The Sun also rises* or *Under the Blood-Red Sun,* and with **year** less than 1950. Plus second: with **is\_good** equals *true*.

`email like "@directual.com" AND name != ""`— finds objects with **email** field similar to *<team@directual.com>*, or *<hello@directual.com>*, and with not empty **name** field.

`birth_date <= "2000-04-09T00:00:00"`— finds objects with **birth\_date** before *9th April 2000.*

{% hint style="info" %}
Note that all values for comparison must be enclosed in quotes. Numbers can be compared with or without quotes.
{% endhint %}

{% embed url="<https://youtu.be/5DuE2t7jzEM>" %}
