Last record

Question

Last record

Navigation

#1 by (3 votes)

0

I need to know how to get the last record stored in the mongo.

I'm doing a search, comparing two IDS, I need to return only the last record.

I have the following variables:

client.name  
client.cpf  
client.endereço

I'm doing the search as follows:

Client.findById({$and: [{_id: client.Client.id}, {_id: contact.id}]}, {sort: {cpf: -1 }}, function(err, clients) {
                  console.log("client.id: "+client.Client.id)
                  console.log("post"+post)
                  console.log("imprimir: "+contact.code)
                  console.log("nome"+client.cpf)
                callback();
              });
            },

But it does not work.

mongodb mongoose

asked by anonymous 24.06.2015 / 16:18

1 answer

How to identify a 'delimiter' in a string with php? Could not find driver (PDOException "could not find driver")

score 3 · Answer 1

Nodejs , if it is Mongoose 3.8+, you can use the syntax:

model.findOne().sort({ field: 'asc', _id: -1 })

Or

model.findOne().sort({ field: -_id })

That is, cpf -1 does not seem to satisfy the order, use a "decrementable" field as ID or dates, since the CPF does not follow an order.

(...) {sort: {id: -1 }} (...)

Example

Client.findById({$and: [{_id: client.Client.id}, {_id: contact.id}]}, {sort: {client.Client.id: -1 }}, function(err, clients) {
     // (...)
},