MongoDB Nested Queries

Question

Hello guys I wanted to make a nested query but I can't figure out how to do it. I want to see if the last name or first name occurs in the search result and then to see the user returned from it are plumbers. I am stuck on how to make a nested query in which I can see if the first name is a substring of the searched name or last name is the substring of the searched name. Any help would be appreciated. I have googled but I can't find a solution to this problem

Meteor.user.find({$and:[{"profile.type": "plumber"}, ? ]})

This is a case where writing pseudocode would make the question a lot more clear. So let's say the user types "son" - you want that to match users with, for example, the first name or "Wilson", or the last name of "Robinson"? I'm confused about the plumbers requirement - do you only want to search for plumbers or you want a result set first? — David Weldon
– David Weldon, Commented Oct 19, 2015 at 12:42
@DavidWeldon the type of the user is plumber and from them I have to get those elements which has son in their name. or we can say it like this too that we get the user whose name has son in them like Robinson or Wilson and then from that result we get those who are plumbers — Gardezi
– Gardezi, Commented Oct 19, 2015 at 13:11

David Weldon · Accepted Answer · 2015-10-19 13:29:35Z

1

Give something like this a try:

// search parameters
var search = 'son';
var type = 'plumber';

// regular expression based on the search with case ignored
var re = new RegExp(search, 'i');

// returns (type == 'plumber') AND
// (last contains 'son' OR first contains 'son')
var selector = {
  $or: [{'profile.firstName': re}, {'profile.lastName': re}],
  'profile.type': type
};

// fetch the users
var users = Meteor.users.find(selector).fetch();

You may need to change some of the field names, e.g. I don't know if you use profile.firstName vs profile.firstname, etc.

answered Oct 19, 2015 at 13:29

David Weldon

64.4k11 gold badges152 silver badges146 bronze badges

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

Comments

Mag · Accepted Answer · 2015-10-19 16:28:04Z

1

Aggregation might be nicer, but this should work:

db.user.find({"profile.type": "plumber", $or:[{"profile.name":/james/},{"profile.surname":/james/}]})

So you have $or for name and surname, and all is in one big document with plumber. /james/ is regex, keep in mind you will have to handle uppercase characters somehow.

answered Oct 19, 2015 at 16:28

Mag

3892 silver badges9 bronze badges

Comments

Constantine · Accepted Answer · 2015-10-19 11:35:25Z

0

I think you should use aggregation pipeline for this. You could pipe the output of a $match which checks for first name or last name and then pipe its result to 2nd $match which filters for 'plumbers'

answered Oct 19, 2015 at 11:35

Constantine

1,41615 silver badges19 bronze badges

4 Comments

Gardezi Over a year ago

can you give me an example

Constantine Over a year ago

check the mongodb documentation. Search for aggregation pipeline and $match.

Gardezi Over a year ago

there is one thing I would like to know that is there a way to check whether a string contains the value of the field ??

Constantine Over a year ago

I m not sure but check out $substr and $regex.

Gardezi · Accepted Answer · 2015-10-20 13:08:38Z

0

thanks guys for all the help but I kind of did it this way

  t= Session.get("plumberSearchQuery").split(" ");

  regexQueryString = ".*" +t[0];
  for(var i = 1 ; i < t.length ; i++){
    if (t[i]!= ""){
      regexQueryString= regexQueryString+ "|"
      regexQueryString =regexQueryString+ t[i];
    }
  }
  regexQueryString = regexQueryString + "*."
 return results.find({ $and:[{"profile.type": "plumber"},{$or: [{"profile.firstName": {$regex: new RegExp(regexQueryString, "i")}} , {"profile.lastName": {$regex: new RegExp(regexQueryString, "i")}}]}]});

edited Oct 20, 2015 at 13:08

answered Oct 20, 2015 at 7:51

Gardezi

2,8802 gold badges35 silver badges63 bronze badges

Collectives™ on Stack Overflow

MongoDB Nested Queries

4 Answers 4

Comments

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related