MongoDB random document with WHERE statement

Question

I'm very new to MongoDB and I have a problem. I want to select a random document but with a condition. In SQL I would have done something like this:

SELECT * FROM challenges
WHERE level = 1
ORDER BY RAND()
LIMIT 1

Now I need to do this in MongoDB, but I only get to the point where I select a random value

Challenge.aggregate({
        $sample: {size:1}
},

How can I add an WHERE statement, I've only seen it with challenge.find, but I'm already aggregating.

Any help would be highly appriciated.

Daphoque · Accepted Answer · 2017-05-16 16:52:36Z

1

 Challenge.aggregate([
 {
   $match:{
     field1: condition1,
     field2: condition2
   }
 },
 {
    $sample: {size:1}
 }
])

answered May 16, 2017 at 16:52

Daphoque

4,6781 gold badge24 silver badges35 bronze badges

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

1 Answer 1