In
In allows you to specify multiple values of same column. It is a shorthand for multiple or query.
Sql
Select * From Table_Name
Where
Column_Name In (value1, value2, ...);
JsStore
connection.select({
from: "Table_Name",
where: {
Column_Name: {
in: [value1, value2, ...]
}
}
}).then(function(results) {
//results will be array of objects.
console.log(results);
}).catch(function(error) {
alert(error.message);
});