Sequelize Op.or within Op.and for nested operations

user_9565558 0
Viewed 2360

I want to make the condition

(A AND B) And (C Or D Or E Or F)

When I try to do

where: {
  [Op.and]: [{
    A,
    B,
    [Op.or]: [{
        C,
        D,
        E,
        F
     }]
  }]
}

This operation will just return A And B AND C AND D AND E AND F, for some reason Op.or just fails within Op.and. Maybe there is a better way to do the logical operation, would anyone know what do?

sequelize.js node.js database
2 Answers

Try below,

where: {
  [Op.and]: [
    {
      A
    },
    {
      B
    },
    {
      [Op.or]: [{
        C,
        D,
        E,
        F
     }]
    }
  ]
}

See the syntax for [Op.and] here.

user_92667090

I fixed this problem by getting rid of the arrays, for some reason they were interfering in the interpretation. I guess you're not allowed to wrap Op.or with Op.and

            [Op.and]: {
                A',
                B,
                [Op.or]: {
                    C,
                    D,
                    E,
                    F
                },
            }
user_95655580
Related