Crafting a sequelize WHERE IN using multiple columns

Question

In MySQL (And other dbs), you can do a where in query with multiple columns like below:

SELECT * FROM trains WHERE (name, location) IN (('train1', 'us'), ... ,('train2', 'us'));

I'm trying to do this with sequelize:

const selectTrains = [
    {name: 'train1', location: 'us'},
    {name: 'train1', location: 'eu'},
    {name: 'train2', location: 'us'},
];

let dbTrains = await Trains.findAll({ where: { [Op.in]: selectTrains} });

But I get the following error:

UnhandledPromiseRejectionWarning: Error: Invalid value {name: 'train1', location: 'us'}

The documentation didn't really cover this use case. Is this possible to do with the Op.in operator?

In most languages, this ends up just having to be a concatenated string, sadly — Joe Phillips
– Joe Phillips, Commented Apr 24, 2018 at 15:54

Vivek Doshi · Accepted Answer · 2018-04-25 03:56:45Z

2

You can achieve the same thing with $or :

const selectTrains = [
    {name: 'train1', location: 'us'},
    {name: 'train1', location: 'eu'},
    {name: 'train2', location: 'us'},
];

Trains.findAll({ where: { $or : selectTrains} });

answered Apr 25, 2018 at 3:56

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

2 Comments

Blue Over a year ago

I have noticed that I can do this, but it creates a massive OR statement, which is significantly less performant (By almost a factor of 3) than a WHERE IN statement.

Vivek Doshi Over a year ago

@FrankerZ , then other option is to run raw query via sequelize.

saisanthosh s · Accepted Answer · 2021-10-27 04:34:04Z

0

Instead of **$or** use **Op.or**        
const selectTrains = [
            {name: 'train1', location: 'us'},
            {name: 'train1', location: 'eu'},
            {name: 'train2', location: 'us'},
];
        
// Trains.findAll({ where: { $or : selectTrains} });
 Trains.findAll({ where: { [**Op.or**] : selectTrains} });

answered Oct 27, 2021 at 4:34

saisanthosh s

1

2 Comments

Sworup Shakya Over a year ago

Please add description to your question.

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Crafting a sequelize WHERE IN using multiple columns

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related