How do I count records after a specific date in Sequelize?

Question

I am creating an API in Nodejs using Sequelize to facilitate the manipulation of data from a Mysql database. I have a list of appointments and I need to count how many appointments a patient has from today’s date.

I saw in the documentation that using [Op.gte] i can filter an age or things involving whole numbers. But I tried to use with Moment.js and the function Date and it didn’t work.

I tried the following, without success:

const pacienteConsultas = await sequelize.models.consulta.count({
  where: {
    paciente_id: paciente_id,
    data_hora: [Op.gte]: Date.now()
  }
});

How can I do?

Answer 1

The problem is that you are passing an invalid value as an object: data_hora: [Op.gte]: Date.now()

The right thing would be data_hora: { [Op.gte]: Date.now() }

If with Date.now() not working, use new Date(). You can find a similar example with Date in documentation.

---

If you want to add more than one condition to the same column, the procedure is similar, placing all conditions within a single object with the column name:

/* Selecionar data_hora entre hoje e amanhã (considerando o dia e hora) */
{
  where: {
    data_hora: {
      [Op.gte]: new Date(),
      [Op.lte]: new Date(Date.now() + 24 * 60 * 60 * 1000);
    }
  }
}