I have an SQLite database with a table named BoxActivity. I need to query this DB to fetch records of a specific month of a year to make a report I've written the query:
BoxActivity.findAll({
attributes: [
[sequelize.fn('SUM', sequelize.col('boxActivity.quantity')), 'total_qty']
],
where: {
quantity: {
[Op.lt]: 0
},
[Op.and]: [
…
Top comments (0)