Sequelize error when using "where" and "in" on a subarray

Question

This is my model definition:

var Tag = sequelize.define('Tag', {
    name: Sequelize.STRING
});

var Event = sequelize.define('Event', {
    name: Sequelize.STRING,
});

Event.hasMany(Tag, {as: 'tags', through: 'event_tags', foreignKey: 'eventId'});
Tag.hasMany(Event, {as: 'events', through: 'event_tags', foreignKey: 'tagId'});

In words this is: there are events and tags. Events are tagged with many tags.

I'm trying to run this query:

Event
.findAndCountAll({
    include: [{model: Tag, as: 'tags'}],
    where: {'tags.id': {in: [1,2,3,4]}},
    order: order,
    limit: pageSize,
    offset: pageSize * (page - 1),
})
.success(function(result) {

    ...
});

But I'm getting this error:

   \node_modules\sequelize\lib\dialects\abstract\query-generator.js:1134
          var logicResult = Utils.getWhereLogic(logic, hash[key][logic]);
                                                                ^
   TypeError: Cannot read property 'in' of undefined

What am I doing wrong?

I've used before the "in" expression, for example here:

 Tag
 .find({
      where: {id: {in: [1,2,3,4]}}
 }).success(...)

And it worked just fine.

I've never used the in expression with a sub-array though, as in this case. So I don't know if thats the correct way to do it.

Antti · Accepted Answer · 2018-01-17 05:52:24Z

226

No need "in" property, sequelize auto define this. Just set array.

Tag.findAll({
    where: {
        id: [1,2,3,4]
    }
}).then(...)

edited Jan 17, 2018 at 5:52

Antti

1011 silver badge8 bronze badges

answered Jul 30, 2014 at 3:33

enxtur

2,5451 gold badge18 silver badges16 bronze badges

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

4 Comments

sports Over a year ago

My last piece of code in my question (the one that you are "fixing") is already ok. Please read the entire post:)

Emanuela Colta Over a year ago

Enxtur, I tried it with findAll and only this way all the records with an id in that array were displayed. Otherwise, only the record with the value of the id equal to the value of the first element in the array will be displayed. Thank you for your help! It was very useful! Tag.findAll({ where: { id: [0,1,2,3] } }).then( tag => { res.json( tag ); });

enxtur Over a year ago

@Emanuelacolta It was misunderstood question and wrong answer, cause my bad english. But i'm happy for it is useful to someone :)

yogithesymbian Over a year ago

other query its work but some condition in my case i got problem with naming export excel because using to long name by filter on in expression then i didnt catch on generate an excel file. ah my bad. i think its not work .

Brad · Accepted Answer · 2019-11-19 02:42:43Z

36

Updated example for Sequelize v5:

await Tag.findAll({
  where: {
    id: {
      [Sequelize.Op.in]: [1, 2, 3, 4]
    }
  }
});

answered Nov 19, 2019 at 2:42

Brad

164k57 gold badges380 silver badges559 bronze badges

2 Comments

deepchudasama Over a year ago

Just make sure it's static method not object accessible method.

elshev Over a year ago

It's worth noting the Shorthand syntax for Op.in section with example: id: [1,2,3] // Same as using id: { [Op.in]: [1,2,3] }

RoboticRenaissance · Accepted Answer · 2020-12-03 23:02:04Z

I know this is hella old. But I'm pretty sure what you were looking for is as follows. At least one of these should do the trick. Probably both. I can't test at the moment because I'm in the middle of a 43-files-changed spaghetti code beast. I'll update with an actual test when I find the time.

(I'm posting now because all the rest seem to not actually answer the question asked, but they did answer the question I had when I arrived here.)

Event
.findAndCountAll({
    include: [{model: Tag, as: 'tags'}],
    where: {
      tags: {
        id: {in: [1,2,3,4]}
      }
    },
    order: order,
    limit: pageSize,
    offset: pageSize * (page - 1),
})
.success(function(result) {

    ...
});

Event
.findAndCountAll({
    include: [
      {
        model: Tag,
        as: 'tags',
        where: { id: {in: [1,2,3,4]} },
      }
    ],
    order: order,
    limit: pageSize,
    offset: pageSize * (page - 1),
})
.success(function(result) {

    ...
});

sametcodes · Accepted Answer · 2019-08-21 10:35:02Z

0

in property able to use at version 4.42

Tag.findAll({
    where: { id: {in: [1,2,3,4]} }
}).then(...)

And you can use notIn property for excluded values.

Tag.findAll({
    where: { id: {notIn: [1,2,3,4]} }
}).then(...)

http://docs.sequelizejs.com/manual/querying.html#operators

edited Aug 21, 2019 at 10:35

answered Jun 26, 2019 at 9:04

sametcodes

5536 silver badges8 bronze badges

1 Comment

Eli Zatlawy Over a year ago

This does not work in sequelize version 6.

jaddu nikhileswararao · Accepted Answer · 2018-03-14 06:40:08Z

-7

replace in with $in

where : { id : { $in : [1,2,3,4]}}

edited Mar 14, 2018 at 6:40

answered Mar 12, 2018 at 7:09

jaddu nikhileswararao

235 bronze badges

2 Comments

AJB Over a year ago

The above contributor (Jaddu) has confused the syntax in their answer with the similar $in operator for MongoDB. It is NOT the same as the in operator that Sequelize offers, and the answer provided by Enxtur above, which eliminates the operator altogether in favour of an array value is the correct solution to the problem.

fith Over a year ago

They aren't confusing it with MongoDB and their answer was still somewhat reasonable in 2018. sequelize.org/v4/manual/tutorial/querying.html "For backward compatibility reasons Sequelize sets the following aliases by default - $eq, $ne, $gte, $gt, $lte, $lt, $not, $in, $notIn…" I'm here looking for something else, but that stuck out.

Collectives™ on Stack Overflow

Sequelize error when using "where" and "in" on a subarray

5 Answers 5

4 Comments

2 Comments

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

2 Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related