check if value exists in array field in mongodb

Question

I want to check if user id exists inside an array field of mongodb (using meteor)

db.posts.find().pretty()

 {
        "_id" : "hT3ezqEyTaiihoh6Z",
        "body" : "hey\n",
        "authorId" : "AyJo5nf2Lkdqd6aRh",
        "createdAt" : ISODate("2016-05-13T06:19:34.726Z"),
        "updatedAt" : ISODate("2016-05-13T06:19:34.726Z"),
        "likecount" : 0,
        "already_voted" : [ ] }

 db.posts.find( { _id:"hT3ezqEyTaiihoh6Z"},{ already_voted: { $in : ["AyJo5nf2Lkdqd6aRh"]} }).count()

 1

It gives count value 1 , where as I am expecting it to be 0 .

SuleymanSah · Accepted Answer · 2020-04-05 16:58:13Z

24

Your logic is fine. Just the syntax is wrong.

db.posts
  .find({
    _id: "hT3ezqEyTaiihoh6Z",
    already_voted: { $in: ["AyJo5nf2Lkdqd6aRh"] },
  })
  .count();

This should work.

edited Apr 5, 2020 at 16:58

SuleymanSah

18k6 gold badges38 silver badges60 bronze badges

answered May 13, 2016 at 6:39

Sudheer Jami

7576 silver badges15 bronze badges

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

Comments

Divyeshkumar Pujari · Accepted Answer · 2021-10-01 08:59:41Z

5

You can just simply use count method. Don't need to use two operation like Find and then count.

db.posts
  .count({
    _id: "hT3ezqEyTaiihoh6Z",
    already_voted: { $in: ["AyJo5nf2Lkdqd6aRh"] }
  });

answered Oct 1, 2021 at 8:59

Divyeshkumar Pujari

511 silver badge2 bronze badges

Collectives™ on Stack Overflow

check if value exists in array field in mongodb

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related