Update array of models at once using .merge function

[3adel-bassiony]

Hello
Is there a way to update multiple items with the same type and value using the merge function?
for example something like this, but this will return an error because merge not working with arrays

        const items = await Item.query().where('name', 'test')
        await items.merge({ deletedAt: DateTime.now() }).save()

I know I can use for loop but I'm asking if there is something better to update the array at once

[tomgobich]

You can do this all in one call using the update method on the query.

await Item.query().where('name', 'test').update({ deletedAt: DateTime.now() })

https://docs.adonisjs.com/guides/models/crud-operations#update

[3adel-bassiony]

@tomgobich Thank you 💪

[tomgobich]

Anytime! :)