按城市、地址、州、mls号码搜索

Question

`我在mongodb中有一个列表，因此每个列表都包含以下字段：

{
  "city" : "Yucca Valley",
  "county" : "San Bernardino",
  "fullStreetAddress" : "7496 CHULA VISTA Avenue",
  "state" : "CA",
  "zipCode" : "92284",
  "streetName" : "7496",
  "streetNumber" : "CHULA VISTA",
  "mls" : "41462506"
}

我有一个搜索输入，并且我正在尝试编写一条语句，该语句按该列进行搜索并返回结果。查询按空格拆分searchQuery，并按每个单词进行搜索。对于Yucca，它返回正确的结果，但对于Yucca Valley或Yucca Valley CA，它工作不正确。

下面是我的搜索查询：

 var searchQuery = req.param('q') ? req.param('q').trim() : null;
      if (searchQuery) {

          var searchQueryArray = searchQuery.split(" ");
          var page = req.param('page') ? req.param('page') : 1;
          var pageData = {};

          var query =  Property.find()

          searchQueryArray.forEach(
              function (queryItem){
                  var orNumeric = [];
                  var orStrings = [];

                  console.log(queryItem);

                  // check, if word contains only numbers, compare it to numeric fields
                  if(/^\d+$/.test(queryItem)){
                      orNumeric.push({streetNumber: {like: "%" + queryItem + "%"}});
                      orNumeric.push({zipCode: {like: "%" + queryItem + "%"}});
                      orNumeric.push({mls: {like: "%" + queryItem + "%"}});
                      query.where({or: orNumeric});
                  } else {
                      orStrings.push({streetName: {like: "%" + queryItem + "%"}});
                      orStrings.push({city: {like: "%" + queryItem + "%"}});
                      orStrings.push({state: {like: "%" + queryItem + "%"}});
                      query.where({or: orStrings})
                  }
              }
          );

          query.where({or: [
              {"fullStreetAddress": {like: "%" + searchQuery + "%"}}
          ]});

我猜，这是因为最后一个where覆盖了前面的。有谁能建议如何修改这个查询，使其返回正确的结果。

Answer 1

我用.native()而不是.query()解决了这个问题。

 var searchQueryArray = searchQuery.split(" ");
 var andQuery = [];

 searchQueryArray.forEach(
    function (queryItem) {
       var orNumeric = [];
       var orStrings = [];


                // check, if word contains only numbers, compare it to numeric fields
        if (/^\d+$/.test(queryItem)) {
             orNumeric.push({"streetNumber": {'$regex': ".*" + queryItem + ".*"}});
             orNumeric.push({"zipCode": {'$regex': ".*" + queryItem + ".*"}});
             orNumeric.push({"mls": {'$regex': ".*" + queryItem + ".*"}});
             andQuery.push({"$or": orNumeric})
          } else {
             orStrings.push({"streetName": {'$regex': ".*" + queryItem + ".*"}});
             orStrings.push({"city": {'$regex': ".*" + queryItem + ".*"}});
             orStrings.push({"state": {'$regex': ".*" + queryItem + ".*"}});
             orStrings.push({"fullStreetAddress": {'$regex': ".*" + queryItem + ".*"}});
             andQuery.push({"$or": orStrings})
                }
            }
 );
 Listing.native(function (err, collection) {
     if (err) return res.serverError(err);
     collection.find({"$and": andQuery})
               .sort({"createdAt": -1})
               .toArray(function (err, matchedListings) {
                   if (err){
                      return res.serverError(err);
                   } 
                   else {
                      console.log("Continue code")
                   }
                })
     })