MongoDB - Select where array contains a document field

Question

The documents in my collection("users") look like this:

{
    _id: ObjectID(...),
   verifiedFields:
   {
       email: ["[email protected]", "[email protected]"],
       phone: [...]
   },
   profiles:
   [
       {
           _id: ObjectID(...),
           fields: 
           {
                email: { value: "[email protected]" }
           }
       }
   ]
}

I would like to now select all users who's profiles.field.email.value is contained within their verifiedFields.email. I would like to avoid having to store a boolean verified as the user should be allowed to have multiple profiles with the same fields and this would cause complications later on. Thanks in advance!

Simply a set of documents from the users-collection where the email has been verified. — l'arbre
– l'arbre, Commented Sep 21, 2018 at 17:54

galkin · Accepted Answer · 2018-09-21 21:43:46Z

1

Your query is:

db.users.find({
  $expr: {$gt: [{$size: {$setIntersection: ['$profiles.fields.email.value', '$verifiedFields.email']}}, 0]}
})

This query doesn't use indexes, so on performance issue you will need add verified field.

Please, check aggregation pipeline and $expr for better understanding this query. Pipeline used for testing your query was:

db.test.aggregate([
  { $addFields: {a : '$profiles.fields.email.value'}},
  { $addFields: {b: { $setIntersection: ['$a', '$verifiedFields.email']}}},
  { $match: {$expr: {$gt: [{$size: '$b'}, 0]}}}
])

answered Sep 21, 2018 at 21:43

galkin

5,5673 gold badges37 silver badges52 bronze badges

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

Comments

Isaac Vidrine · Accepted Answer · 2018-09-21 18:46:20Z

0

something like this should work:

collection('users').find({
    'profiles[0].fields.email.value': {$in: 'verifiedFields.email'}
})

answered Sep 21, 2018 at 18:46

Isaac Vidrine

1,6761 gold badge12 silver badges21 bronze badges

1 Comment

Adam Over a year ago

$in only takes arrays and can't interpret them from strings.

Collectives™ on Stack Overflow

MongoDB - Select where array contains a document field

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related