Mongoose DB - Find inside an array

Question

I have the following data inside a mongoose collection:

{
  map: 'Sydney',
  Postcode: 2000,
  mapItems: [
    {
      team: 'NONE',
      teamIcon: 20,
      x: 0.6092914,
      y: 0.28168318,
      flags: 0
    },
    {
      team: 'Alpha',
      teamIcon: 33,
      x: 0.63026464,
      y: 0.41642973,
      flags: 0
    },
    {
      team: 'Bravo',
      teamIcon: 20,
      x: 0.63026464,
      y: 0.41642973,
      flags: 0
    },
    {
      team: 'Alpha',
      teamIcon: 20,
      x: 0.63026464,
      y: 0.41642973,
      flags: 0
    }

}

I'm trying to return just the mapItems that have the team as "Alpha" and teamIcon is 33 or 52.

dyDB
    .find({
      $or: [
        {
          "mapItems.teamIcon": 33,
        },
        {
          "mapItems.teamIcon": 52,
        },
      ],
      $and: [
        {
          "mapItems.teamId": "Alpha" },
        },
      ],
    })
    .then((data) => {
      for (const dyn of data) {
        console.log(dyn);
      }
    });

But it just returns everything and doesn't seem to filter it. I'm not sure what else to try. Can anyone give some pointers?

Mani · Accepted Answer · 2021-11-30 11:19:02Z

1

You have to use or inside and:

dyDB.find({
    mapItems: {
      $elemMatch: {
        $and: [
          { $or: [{ teamIcon: 52 }, { teamIcon: 33 }] },
          { team: "Alpha" },
        ],
      },
    },
  })
  .then((data) => {
    for (const dyn of data) {
      console.log(dyn);
    }
  });

edited Nov 30, 2021 at 11:19

answered Nov 30, 2021 at 8:33

Mani

2902 silver badges10 bronze badges

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

6 Comments

Yesman Over a year ago

It is still returning everything, nothing is being filtered.

Mani Over a year ago

@Yesman, dot operator removed, can you check now

Yesman Over a year ago

Now I am getting MongoServerError: unknown operator: $and

Mani Over a year ago

@Yesman, i fixed syntax, can you try now

Yesman Over a year ago

"TypeError: conditional $and requires an array" is now coming up

|

Collectives™ on Stack Overflow

Mongoose DB - Find inside an array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related