Menu
I'm trying to use the $in operator in SequelizeJS as you would in a MySQL statement:
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
In my case, I've joined three tables, but I don't believe that's related to the issue. I keep getting this error Error: Invalid value { '$in': ['12345','67890','15948'] } with the following code:
definedTable.findAll({
include: [{
model: definedTableTwo,
where: {
zip_code: {
$in: ['12345','67890','15948']
}
},
required: true,
plain: true
},
{
model: definedTableThree,
required: true,
plain: true
}]
})
Can someone provide some insight on how to use the $in operator? The only examples I've seen are with integers within the array when searching Ids.
589
You need to import the object from Sequelize to use it in your code: const { Sequelize, Op } = require("sequelize"); When you call the query methods from your model, you can use the Op object properties to create SQL queries with operators.
Sequelize where option accepts an object describing the WHERE clause to add to your generated SQL query. For a WHERE clause with a simple condition, you can add a single property to the where object. The property name will be the column name and the property value will be the value you use to filter the query.
As there are often use cases in which it is just easier to execute raw / already prepared SQL queries, you can use the sequelize. query method. By default the function will return two arguments - a results array, and an object containing metadata (such as amount of affected rows, etc).
Just reading the docs here Sequelize WHERE
I'd try :
const Op = Sequelize.Op;
definedTable.findAll({
include: [{
model: definedTableTwo,
where: {
zip_code: {
[Op.in]: ['12345','67890','15948']
}
},
required: true,
plain: true
},
{
model: definedTableThree,
required: true,
plain: true
}]
})
Does that help ?
53
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
