In Mongoose, query fields based on array

Question

I am trying to query documents from a mongodb collection, based on array of input query parameters sent from URL.

Sample Database Data

[
    {
        "drawings": {
            "circle": [],
            "square": [
                {
                    "id": "828",
                    "name": "square"
                }
            ],
            "cube": []
    },
    {
        "drawings": {
            "circle": [
                {
                    "id": "827",
                    "name": "circle"
                }
            ],
            "square": [],
            "cube": []
    },
    {
        "drawings": {
            "circle": [],
            "square": [],
            "cube": [
                {
                    "id": "829",
                    "name": "cube"
                }
            ]
    }
]

Input Query Parameter:

query = ["square","cube"];

Expected Output:

[
    {
        "drawings": {
            "circle": [],
            "square": [
                {
                    "id": "828",
                    "name": "square"
                }
            ],
            "cube": []
    },
    {
        "drawings": {
            "circle": [],
            "square": [],
            "cube": [
                {
                    "id": "829",
                    "name": "cube"
                }
            ]
    }
]

Best suited Mongoose Query:

Schema.find({
    $or:[
        {'drawings.square':{$elemMatch:{ name:'square'}}},
        {'drawings.cube':{$elemMatch:{ name:'cube'}}}
    ]
});

Tried Below method. But, it is not correct.

let draw = ["square","cube"];
let draw_query =[];
for (let a=0; a<draw.length;a++){
    draw_query.push("{\"drawings."+ draw[a] +"\':{$elemMatch:{ name:\"" + draw[a] + "\"}}}");
}

It creates array with single quoted strings. It cannot be used.

[ '{"drawings.square":{$elemMatch:{ name:"square"}}}',
  '{"drawings.cube":{$elemMatch:{ name:"cube"}}}' ]

How to generate this mongoose query dynamically? or is there any better mongoose query to achieve the expected result.

mickl · Accepted Answer · 2019-01-21 10:55:11Z

1

You can query it directly using dot notation so the query should look like below:

db.collection.find({
  $or: [
    {
      "drawings.square.name": "square"
    },
    {
      "drawings.circle.name": "circle"
    }
  ]
})

You can build it in JS using .map(), try:

var query = ["square","cube"];
var orQuery = { $or: query.map(x => ({ [x + ".name"]: x }) ) }

answered Jan 21, 2019 at 10:55

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

In Mongoose, query fields based on array

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