best way to execute dynamic mongoDB queries in Nodejs

Question

i have a variable that can either be an array of string or be an empty array.

const userHospitalQuery = [ req.query.hospital || [] ].flat();

when i filter with is as an array of strings, it works fine. Im running into a problem when i try to run my mongo search with the variable not having any values or empty (no Query pass in the url), how do I make mongo skip or ignore it as part of the filters? so only my other 2 filters are applied to the search. i know i cant use if statements inside my query object so im not sure what to do

const userHospitalQuery = [req.query.hospital || []].flat();

const filter = {
  "staff.hospital": { $in: userHospitalQuery }, // How do i ignore/skip this if no query is passed in the URL
  organisation: { $eq: "Test" },
  isDeleted: { $eq: false },
};

const staff = await User.find(filter).sort({ dateAdded: -1 });

SuleymanSah · Accepted Answer · 2021-08-22 17:16:24Z

1

Just modify the filter object with a regular if.

const userHospitalQuery = [req.query.hospital || []].flat();

const filter = {
  organisation: { $eq: "Test" },
  isDeleted: { $eq: false },
};

if (userHospitalQuery.length) {
  filter["staff.hospital"] = { $in: userHospitalQuery };
}

const staff = await User.find(filter).sort({ dateAdded: -1 });

edited Aug 22, 2021 at 17:16

SuleymanSah

18k6 gold badges38 silver badges60 bronze badges

answered Aug 22, 2021 at 17:13

AKX

171k16 gold badges146 silver badges228 bronze badges

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

Collectives™ on Stack Overflow

best way to execute dynamic mongoDB queries in Nodejs

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