Sequelize findOne latest entry
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.
model.findOne({
where: { key },
order: [ [ 'createdAt', 'DESC' ]],
});
Method findOne
is wrapper for findAll
method. Therefore you can simply use findAll
with limit 1 and order by id descending.
Example:
YourModel.findAll({
limit: 1,
where: {
//your where conditions, or without them if you need ANY entry
},
order: [ [ 'createdAt', 'DESC' ]]
}).then(function(entries){
//only difference is that you get users list limited to 1
//entries[0]
});