Shapes

Subtopics

EdgeQL Tutorial

Shapes

It's possible to fetch an object and its links as a nested structure. This is done by using nested shapes. For example, to fetch an Account and all the stuff on the watchlist try:

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

To add the names of all the characters and who played them we will need to add one more level of nesting. Also, we will fetch a link property by using the @ symbol in front of the field name. Since the names of the characters depend on the movie, they are stored in a link property character_name of the link actors. Try the following query to fetch all of these details:

Input

Run

select Account {
  username,
  watchlist: {
    title,
    actors: {
      name,
      @character_name,
    }
  }
} filter .username = 'Alice';

select Account {
  username,
  watchlist: {
    title,
    actors: {
      name,
      @character_name,
    }
  }
} filter .username = 'Alice';

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.