query for empty array in "include" model field

Question

Let’s say I have foo and I make it include bar model,
They are many to many relationship.
While bar model contains a column called clients, which is an array in nodejs.

foo.findAll({
    where      : where,
    include    : [{ model: bar}]
})

How should I use foo.findAll to get all data which bar must be an empty array.

which field hast to be in model bar it can be id or any other column you have in model bar ?? — Aryan
– Aryan, Commented Oct 14, 2020 at 8:15

Aryan · Accepted Answer · 2020-10-14 08:21:59Z

1

You can simply Do it like this I am suggesting this because your question is unclear

foo.findAll({
    where: where,
    include: [{
        model: bar,
        where: { name: { [Op.is]: null } }
    }]
})

above code will return data of model bar where name as no value or the field is null

answered Oct 14, 2020 at 8:21

Aryan

3,6465 gold badges23 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

query for empty array in "include" model field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related