how to skip query exection if input array is empty or not exit in mongoose aggregate

Question

I need to find record by using aggregate query, and if any of given input is empty array then need to skip that query. In the below code, i have give one empty array to "brandFilter", then that query need to skip $in execution. If it has some array [one, two], then it will give related matched output

Example

{ $filter: {
                    input: '$products',
                    as: 'item',
                    cond: {  $and: [
                        {
                            $gte: ['$$item.prodprice', Number(price)],
                        },
                        { $in: [ "$$item.brand", brandArr ] }  
                    ]}
                }}

Himanshu Sharma · Accepted Answer · 2019-09-23 17:14:21Z

1

The following filter would get us the expected output:

{
    $filter:{
        "input":"$products",
        "as":"item",
        "cond":{
            $and:[
                {
                    $gte: ['$$item.prodprice', Number(price)]
                },
                {
                    $or:[
                        {
                            $eq:[brandArr[0],undefined]
                        },
                        {
                            $in: [ "$$item.brand", brandArr ]
                        }
                    ]
                }
            ]
        }
    }
}

answered Sep 23, 2019 at 17:14

Himanshu Sharma

3,0202 gold badges10 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

how to skip query exection if input array is empty or not exit in mongoose aggregate

Example

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Example

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related