converting mongoDB query to Java (Distinct with sort)

Question

I want to create java code for the below mongoDB query. Since i am new to mongoDB cananyone help on this

db.getCollection('dum_stats').distinct("engineNo").sort();

please add anything you have tried so far

s7vr
– s7vr

2016-12-05 10:34:48 +00:00
Commented Dec 5, 2016 at 10:34 — s7vr
– s7vr, Commented Dec 5, 2016 at 10:34

s7vr · Accepted Answer · 2016-12-05 11:56:31Z

1

Here is a sample example for Mongo 3.x version.

MongoClient mongoClient = new MongoClient();
MongoDatabase db  = mongoClient.getDatabase("yourdb")
MongoCollection<Document> collection = db.getCollection("dum_stats");
FindIterable<Document> distinct = collection.distinct("engineNo", Document.class);
distinct.sort(Sorts.descending("engineNo"));

edited Dec 5, 2016 at 11:56

answered Dec 5, 2016 at 10:48

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

4 Comments

user2000189 Over a year ago

There is no method as sort. FindIterable<Document> distinct = collection.distinct("engineNo", Document.class).sort(null);

s7vr Over a year ago

Updated. Try now.

user2000189 Over a year ago

Yes it is available, but it expects a Bson object as argument, i want to provide sort like distinct.sort(-1);

Vibhav Chaddha Over a year ago

Hi, @user2683814 Your solution is giving me an error "Type mismatch: cannot convert from DistinctIterable<Document> to FindIterable<Document>" for collection.distinct. What should I do regarding it? Thanks in advance.

Collectives™ on Stack Overflow

converting mongoDB query to Java (Distinct with sort)

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related