Filters

Subtopics

EdgeQL Tutorial

Filters

Object properties can be used to filter the results. For example, to query only the user matching a specific name try:

Input

SELECT User {
    name,
    email
} FILTER User.name = 'Alice';

SELECT User {
    name,
    email
} FILTER User.name = 'Alice';

Run

Output

Press the 'Run' button to evaluate the input

When specifying properties in FILTER clause a shorthand can be used. Instead of giving the full path to the property, you can just start with a . and enter the property name directly:

Input

SELECT User {
    name,
    email
} FILTER .email = 'alice@tutorial.com';

SELECT User {
    name,
    email
} FILTER .email = 'alice@tutorial.com';

Run

Output

Press the 'Run' button to evaluate the input

It's possible to refer to a link in a FILTER in the same way that properties are referred to. For example, to get photos made by a specific user try:

Input

SELECT Photo {
    uri,
    post_date
} FILTER .author.email = 'alice@tutorial.com'
ORDER BY .post_date;

SELECT Photo {
    uri,
    post_date
} FILTER .author.email = 'alice@tutorial.com'
ORDER BY .post_date;

Run

Output

Press the 'Run' button to evaluate the input

Prev Next