Question 309306 in Javascript Question posted in
A very good W3school tutorial can be found here.

Javascript – How to find an element in an object within an array with 2 conditions using mongoose?

I’m looking to use mongoose to find a document based on a query that finds two property values within an object which is in an array. I used the code shown below but it didn’t work as expected – it returned documents that contained "kiosk" in the name and also any equipment item in the array that had a count of 3. I want it to only return documents with an equipment name of kiosk and only if it has 3 kiosks. Can anyone assist?

  if (equipment && equipment !== "All") {
    const projects = await Project.find({
      $and: [
        {
          "equipment.name": "kiosk",
          "equipment.count": 3,
        },
      ],
    });
    res.status(StatusCodes.OK).json({ projects });
    
    return;
  }

All I’ve tried so far is what I’ve shown. Any suggestions would be appreciated.

Tags:

2

Answers


  1. 0

    I think you should use $elemMatch operator in mongoose. This used to query array elements that match multiple record.

    const projects = await Project.find({ equipment: { $elemMatch: { name: "kiosk", count: 3, }, }, });

    Login or Signup to reply.
  2. 0

    Your current query is close, but the use of $and is not necessary in this case since you’re specifying multiple conditions for the same field. You can directly use an object with multiple properties inside the find method.

    if (equipment && equipment !== "All") {
  const projects = await Project.find({
    "equipment.name": "kiosk",
    "equipment.count": 3,
  });
  res.status(StatusCodes.OK).json({ projects });
  return;
}

    Update:

    If you want to ensure that only the equipment item with the name "kiosk" has a count of 3, you can use the $elemMatch operator to specify conditions on elements within an array.

    if (equipment && equipment !== "All") {
  const projects = await Project.find({
    equipment: {
      $elemMatch: {
        name: "kiosk",
        count: 3,
      },
    },
  });
  res.status(StatusCodes.OK).json({ projects });
  return;
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search