Do not query against parameters that are equal to NULL in mongoose?

Question

If I have the following DB model in mongoose

Employee{
    FirstName : String,
    LastName : String,
    Job  : String,
}

and I have two docs that look like this:

{
   FirstName : Bob,
   LastName : Jackson
   Job : Professor
}

{
   FirstName : Michael,
   LastName : Jackson,
   Job : Professor,
}

if I have a query that does the following:

Employee.find{FirstName : "Michael" , LastName : NULL,  Job : NULL}

It will return null.

Instead I want to ignore the fields that have parameters equal to NULL as they do not exist in the query and the query above I wanted to be treated as :

Employee.find{“FirstName : Michael”}

how can I do that?

MIKE · Accepted Answer · 2015-11-25 16:45:24Z

1

I just need to do something like

Employee.Find(FirstName : new Regex(firstNameParam,i),
LastName : new Regex(lastNameParam,i),
Job  : new Regex(jobParam,i))

answered Nov 25, 2015 at 16:45

MIKE

1051 gold badge3 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Do not query against parameters that are equal to NULL in mongoose?

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