Meteor MongoDB nested query with AND (two conditions)

Question

I've been struggling for hours. Here's what I need to achieve: find if document exists where both conditions are satisfied: Field1 = 'Value1' and users.userName = 'Value2'

{
  "_id": "eRotXZoKL4aS3KygF",
  "Field1": "Value1",
  "usercount": 1,
  "owner": "Admin",
  "accessType": "Level1",
  "users": {
    "userName": "Value2",
    "expired": false
  }
}

My query

Collection.findOne({},{Field1: channel, users:{userName: nickName}});

returns first match it finds. In other words, it finds the document where users:{userName: 'Value2'}, but disregards, or so it seems Field1: 'Value1'

David Weldon · Accepted Answer · 2016-01-28 22:37:49Z

1

The first parameter to findOne is the selector. Try this:

Collection.findOne({Field1: channel, 'users.userName': nickName});

Mongo uses an implicit AND between all fields in the selector object. Also note that to match a nested object you'll use dot notation to reference embedded documents - in this case, 'users.username'.

answered Jan 28, 2016 at 22:37

David Weldon

64.4k11 gold badges152 silver badges146 bronze badges

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

1 Comment

Florida G. Over a year ago

Yes, that worked. Thanks. Did not think I could use single quotes. Learned something today.

Collectives™ on Stack Overflow

Meteor MongoDB nested query with AND (two conditions)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related