cómo cargar registro de transacciones de cada hora.
if (ExpenseGraphTimeSeries === 'today') { let date = new Date(Date.now()); let createdAt = { [Op.lt]: new Date(date), [Op.gte]: new Date().setHours(0, 0, 0, 0) }; ExpenseGraphCondition.createdAt = createdAt ExpenseGraph = await model.Expense.findAll({ where: createdAt, attributes: [ [model.sequelize.fn('sum', model.sequelize.col('Amount')), 'expense'], 'createdAt' ], }); } La salida de corriente es
| Importe | creado en | | -------- | -------------- | | 2349 | 01-01-2020 00:00:00 | | 2349 | 01-02-2020 00:00:00 |
i need record of every hour with amount of that hour. how to do this?group:[] se usa en Sequelize para devolver datos por grupos. tu codigo sera asi
if (ExpenseGraphTimeSeries === 'today') { let date = new Date(Date.now()); let createdAt = { [Op.lt]: new Date(date), [Op.gte]: new Date().setHours(0, 0, 0, 0) }; ExpenseGraphCondition.createdAt = createdAt ExpenseGraph = await model.Expense.findAll({ where: createdAt, attributes: [ [model.sequelize.fn('sum', model.sequelize.col('Amount')), 'expense'], 'createdAt' ], group: [model.sequelize.fn('hour', model.sequelize.col('createdAt'))], order: [['id', 'asc']], //optional }); }