How to get the last inserted N records from mongodb using Java?

Question

There is an analogous post for using mongodb scripting mongodb: how to get the last N records?

How to achieve the same goal with Java getting the last inserted collection document? Just in case, I am using the 3rd version of the mongodb Java driver, my mongodb dependencies in pom.xml are as follows:

<dependency>
    <groupId>org.mongodb</groupId>
    <artifactId>mongo-java-driver</artifactId>
    <version>3.0.2</version>
</dependency>   
<dependency>
    <groupId>org.mongodb</groupId>
    <artifactId>bson</artifactId>
    <version>3.0.2</version>
</dependency>

Rachit Ahuja · Accepted Answer · 2015-07-22 21:45:11Z

2

Use .limit()

db.foo.find().limit(50);

Or if you want to sort and then get last records then you can do

db.foo.find().sort({_id:1}).limit(50);  and -1 for descending.

answered Jul 22, 2015 at 21:45

Rachit Ahuja

3692 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Rachit Ahuja Over a year ago

Its a java code, You can try doing MongoDatabase db = client.getDatabase("test"); db.collection.find().sort(new Document("x", 1)).limit(n); If you still face problems, you can put the code here. I hope this solves your problem.

Alex Over a year ago

@Rashit, Thank you. What do you mean by ("x", 1), is "x" any field in the document and what is 1 here? How to do "and -1 for descending", what is the code? By the way "db.foo.find().sort({_id:1}).limit(50)" is not compiled.

Rachit Ahuja Over a year ago

Yes x is any field. Yes just use -1 for descending in the same code format as above. Also please accept the answer. Thank you.

Alex Over a year ago

This code is not compiled: FindIterable<Document> currentVersionDocumentIterable = coll.find(); currentVersionDocumentIterable.sort("name", 1).limit(50);

Rachit Ahuja Over a year ago

Try doing coll.find().sort("name",1).limit(50);

|

Alex · Accepted Answer · 2015-07-28 19:23:10Z

1

It is the new syntax in MongoDB version 3, therefore I could not use the suggested answer . So the working code is as follows:

MongoCollection<Document> coll = db.getCollection(<collectionName>);

FindIterable<Document> currentVersionDocumentIterable =   
    coll.find().sort(new Document("_id", -1)).limit(50);

Inside sort one needs to insert “new Document”

answered Jul 28, 2015 at 19:23

Alex

7,61921 gold badges79 silver badges121 bronze badges

Collectives™ on Stack Overflow

How to get the last inserted N records from mongodb using Java?

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related