[Database] Fix Nested Sequelize Operators Querying

gitcoinco / cerebro

2 stars 2 forks source link

Open kamescg opened 4 years ago

kamescg commented 4 years ago

Nested Sequelize Operators aren't working on JSONB type columns.

Supposedly sequelize literals solve this problem.

Example

User.findAll({
  where:
        sequelize.where(
        sequelize.literal('facebook->"$.id"'),
        "1239871587612"
      )
  }
});