Mongoose query to check for specific value in array of searched element

Question

I have s schema like:

var EntitySchema = new Schema({
  name : {type: String, default: null},
  organizations : [{
    id: {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'Organization'
    }}]
});

I have an id of organization, How can I make a query for Entity.find({}) and find Entity that has this id in its organizations array?

I used this in mongo shell

db.entity.find({"organizations.id": { $in: [ObjectId("ididididididid")]}}).pretty()

and it worked, but it doesn't work in express method, do I do something wrong? Does $in works both ways? I have a feeling that its not what I should be using in this query.

What your data looks like? organization: [ { id: ObjectId('hashedvalue44') } ] — mandaputtra
– mandaputtra, Commented Nov 19, 2019 at 12:36
organizations: [{id: 'hashedvalue44'}, {id: 'hashedvalue55'}], or organizations: ['hashedvalue44', 'hashedvalue55'] either is acceptable as of now. — Felix
– Felix, Commented Nov 19, 2019 at 14:31

RameshN · Accepted Answer · 2019-11-19 14:43:50Z

1

As per mongo documentation, you can query as below

db.entity.find({ "organizations" : { $elemMatch: { "id" : ObjectId("ididididididid") } }}).pretty();

Ref: https://docs.mongodb.com/manual/tutorial/query-array-of-documents/

edited Nov 19, 2019 at 14:43

answered Nov 19, 2019 at 12:39

RameshN

5307 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Mongoose query to check for specific value in array of searched element

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related