Light
Dark
System
v4latest
v4latest
v3
v2
v1

Updating data

The types used in these queries are defined here.

Flag all reviews to a specific movie:

Copy
update Review
filter
    Review.movie.title = 'Dune'
    and
    Review.movie.director.last_name = 'Villeneuve'
set {
    flag := True
}

Add an actor with a specific list_order link property to a movie:

Copy
update Movie
filter
    .title = 'Dune'
    and
    .directors.last_name = 'Villeneuve'
set {
    actors := (
        insert Person {
            first_name := 'Timothee',
            last_name := 'Chalamet',
            image := 'tchalamet.jpg',
            @list_order := 1,
        }
    )
}

Using a for query to set a specific list_order link property for the actors list:

Copy
update Movie
filter
    .title = 'Dune'
    and
    .directors.last_name = 'Villeneuve'
set {
    actors := (
        for x in {
            ('Timothee Chalamet', 1),
            ('Zendaya', 2),
            ('Rebecca Ferguson', 3),
            ('Jason Momoa', 4),
        }
        union (
            select Person {@list_order := x.1}
            filter .full_name = x.0
        )
    )
}

Updating a multi link by adding one more item:

Copy
update Movie
filter
    .title = 'Dune'
    and
    .directors.last_name = 'Villeneuve'
set {
    actors += (
        insert Person {
            first_name := 'Dave',
            last_name := 'Bautista',
            image := 'dbautista.jpg',
        }
    )
}

Updating a multi link by removing an item:

Copy
update Movie
filter
    .title = 'Dune'
    and
    .directors.last_name = 'Villeneuve'
set {
    actors -= (
        select Person
        filter
            .full_name = 'Jason Momoa'
    )
}

Update the list_order link property for a specific link:

Copy
update Movie
filter
    .title = 'Dune'
    and
    .directors.last_name = 'Villeneuve'
set {
    # The += operator will allow updating only the
    # specified actor link.
    actors += (
        select Person {
            @list_order := 5,
        }
        filter .full_name = 'Jason Momoa'
    )
}
Light
Dark
System

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.