Trying to use findOne query

Question

Can someone help me understand what I'm dong wrong. I'm trying to fetch the last recorded ID in my mongodb collection

db.collection('task').findOne(({_id: new ObjectID}).sort('_id:: -1').limit(1), (error, task) => {
        if(error){
            return console.log('There is no data inside the collection')
        }
    })

What are you trying to achieve by using`{_id: new ObjectID}` ? — mickl, Dec 07 '19 at 18:19
Does this answer your question? [How to get the last N records in mongodb?](https://stackoverflow.com/questions/4421207/how-to-get-the-last-n-records-in-mongodb) — whoami - fakeFaceTrueSoul, Dec 07 '19 at 18:19
I'm trying to fetch the last recorded document in the collection by id — hippe_paradox, Dec 07 '19 at 18:33
What do you mean by 'last record'? Are you referring to the last saved record, or the actual 'last' record (which would always return the very first saved document)? — Matt Oestreich, Dec 07 '19 at 18:52

score 0 · Answer 1 · answered Dec 07 '19 at 18:55

After constant tries I got this to work

db.collection('task').findOne({}, {sort: {id: -1},limit: 1}, (error, task) => {
        if(error){
            return console.log('There is no data inside the collection')
        }
        console.log(task)
    })

Trying to use findOne query

1 Answers1