Sequelize findOne latest entry

javascript node.js sequelize.js
Noah picture Noah · Feb 17, 2016 · Viewed 61k times · Source

I need to find the latest entry in a table. What is the best way to do this? The table has Sequelize's default createdAt field.

Answer

szym picture szym · Nov 30, 2016 
model.findOne({
    where: { key },
    order: [ [ 'createdAt', 'DESC' ]],
});

Related questions

Sequelize.js delete query?

Is there a way to write a delete/deleteAll query like findAll? For example I want to do something like this (assuming MyModel is a Sequelize model...): MyModel.deleteAll({ where: ['some_field != ?', something] }) .on('success', function() { /* ... */ });

Read More
sequelize table without column 'id'

i have the following sequelize definition of a table: AcademyModule = sequelize.define('academy_module', { academy_id: DataTypes.INTEGER, module_id: DataTypes.INTEGER, module_module_type_id: DataTypes.INTEGER, sort_number: DataTypes.INTEGER, requirements_id: DataTypes.INTEGER }, { freezeTableName: true}); As you …

Read More
Sequelize Where statement with date

I am using sequelize as my backend ORM. Now i wish to do some where operations on a Date. More Speceficly i want to get all data where a date is from now and 7 days back. The problem is that …

Read More