Noah Noah - 3 days ago 6
Javascript Question

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.

Answer

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]
}); 
Comments