How to define condition as variable to find method in mongodb?

Question

I want to use code to manipulate 'condition' as variable before passing into 'find' method (for MongoDB):

let condition;

if (cat) {
   condition = { $and: [{brand: brnd},
                        {category: cat} ] 
               }  
} else { 
   condition = {brand: brnd} 
}

productCol.find(condition);

But I am unable to get this to work. Can anyone help me how I can make it to work? Thank you

Correction to above. Above code actually is working other than my own mistake in value passing that give inaccurate result, with thanks to saketh on the hint below. — elvin
– elvin, Commented Feb 23, 2019 at 18:26

saketh · Accepted Answer · 2019-02-23 16:54:00Z

1

Can you be more specific about your code like how did u setup your connection and how are you trying to use the result and what errors are you getting when you are trying to run your code. Please try the below code.

    var FindQuery=function(cat){
    if (cat) {
    var condition = { $and: [{brand: brnd},
                    {category: cat} ] }  
    } else { 
    var condition = {brand: brnd} 
    }

    return productCol.find(condition);
    };
    FindQuery(condition)

answered Feb 23, 2019 at 16:54

saketh

8131 gold badge11 silver badges25 bronze badges

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

1 Comment

elvin Over a year ago

hi Saketh, I check that your code works (but code in different way). When I test again onto my code, I then realised is the value passing mistake that I make. It works also otherwise. Thank you

Collectives™ on Stack Overflow

How to define condition as variable to find method in mongodb?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related