Mongodb finding distinct values using multiple fields

Question

I am trying to show distinct values of two fields. Not sure it is possible to return values from the two fields in my Mongodb.

I have tried this:

db.sInsert.distinct("post_id","post_message").

But it is not possible to do so.

what do you mean by distinct value on two fields? Is post_id also stored in post_message? Or do you want distinct on combination of post_id and post_message? — sidgate
– sidgate, Commented Feb 6, 2018 at 8:41
Possible duplicate of How to efficiently perform "distinct" with multiple keys? — Ola Karlsson
– Ola Karlsson, Commented Dec 7, 2018 at 7:23

Bùi Đức Khánh · Accepted Answer · 2018-02-06 08:42:41Z

1

You can use $group in aggregation

db.sInsert.aggregate( [ {"$group": { "_id": { post_id: "$post_id", post_message: "$post_message" } } } ]);

answered Feb 6, 2018 at 8:42

4,6787 gold badges32 silver badges46 bronze badges

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

1 Answer 1