Filters

Subtopics

EdgeQL Tutorial

Filters

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

Input

Run

select Account {
  username,
  watchlist: { title }
} filter Account.username = 'Alice';

select Account {
  username,
  watchlist: { title }
} filter Account.username = 'Alice';

Output Objects

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

Run

select Account {
  username,
  watchlist: { title }
} filter .username = 'Alice';

select Account {
  username,
  watchlist: { title }
} filter .username = 'Alice';

Output Objects

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 all the accounts that have a specific movie on the watchlist try:

Input

Run

select Account {
  username
} filter .watchlist.title = 'Dune'
order by .username;

select Account {
  username
} filter .watchlist.title = 'Dune'
order by .username;

Output Objects

Press the 'Run' button to evaluate the input

Prev Next

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.