MongoDB return collections matching one element in query array

Question

This is the database collection - Job:

{
  "skillsRequired": ["html", "css", "javascript"],
  "qualification": [ "BE", "B-Tech"],
  "company" : "microsoft"
},
{
  "skillsRequired": ["html", "ml", "ai", "python"],
  "qualification": [ "BE", "B-Tech"],
  "company" : "microsoft"
},
{
  "skillsRequired": ["ml", "ai", "python"],
  "qualification": [ "BE", "B-Tech"],
  "company" : "microsoft"
}

How can I get the following output when parameter is "skillsRequired" : ["html", "css"]

[{
  "skillsRequired": ["html", "css", "javascript"],
  "qualification": [ "BE", "B-Tech"],
  "company" : "microsoft"
},
{
  "skillsRequired": ["html", "ml", "ai", "python"],
  "qualification": [ "BE", "B-Tech"],
  "company" : "microsoft"
}]

In short, the query should return all the records/documents in which any one of the elements in parameter query matches with that of the document.

wcjord · Accepted Answer · 2020-04-18 19:15:29Z

1

const query = {};

if (skillsRequiredParam && skillsRequiredParam.length > 0) 
    query.skillsRequired = {$in: skillsRequiredParam}
}     
const docs = await db.collection.find(query).exec();

edited Apr 18, 2020 at 19:15

answered Apr 12, 2020 at 9:44

wcjord

5501 gold badge4 silver badges15 bronze badges

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

2 Comments

Jatin Ranka Over a year ago

It is working as expected, but when the parameters skillsRequired array is empty, I want it to return all the documents since no conditions are provided. As of now if the parameters array is empty it is not returning any document.

wcjord Over a year ago

Just passing {} as the query will get all the documents but as soon as put skillsRequired in there, you need to match some terms. Before the call put a check that the array is nonempty and if empty, don't add the query.

Collectives™ on Stack Overflow

MongoDB return collections matching one element in query array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related