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)