如何在Mongo中与$匹配或$ switch语句进行$匹配

Question

嗨，我正在尝试在开关内部进行多个搜索，所以如果以下用户之一：search_data || com：search_data ||水果：serch_data 匹配返回搜索结果。 我想这样做，

$match:{
          $or:[{ user:{$regex:"search_data"}},
          {com:{$regex:"search_data"}},
          {fruit:{$elemMatch: {name:{$regex:"search_data"}}}}
}

如果用户应该搜索用户，这是一个搜索，如果com应该搜索公司，我现在就可以做到这一点，如果我们将全部提供时，如果搜索数据在用户或或 com上退出， 或水果应返回搜索结果

   {
            $match: {
              $expr: {
                $switch: {
                  branches: [
                    {
                      case: {
                        $eq: ['$search', 'all']
                      },
                      then: {
                       
                       //to this
                      }
                    },
                 ],
                 default: {}
              }
            }
          }

样本数据

 user:"rithuwa",
  com:"abc",
  fruit:[{name:"mango",des:"aaaaa"},{name:"mango",des:"nnnn"}]

样本输入

search_data:"rit"---->since this is in user it should output the record
search_data:"mango"--->since it in the fruit.name it should output the record
search_data:"ab"---->since it in the com it should output the record
search_data:"me"---->since it not in user,com or fruit should not give search record  

Answer 1

查询

• 如果类型都是所有其他选中的等级，
• 请根据类型

*在发送查询之前先知道类型其中一个（Bellow在服务器上这样做，并且查询更大，您可以使用4个较小的查询来完成）

Playmongo

aggregate(
[{"$set": {"searchData": "mango", "searchType": "tags"}},
 {"$match": 
   {"$expr": 
     {"$switch": 
       {"branches": 
         [{"case": {"$eq": ["$searchType", "all"]},
            "then": 
             {"$or": 
               [{"$regexMatch": {"input": "$name", "regex": "$searchData"}},
                 {"$regexMatch": {"input": "$company", "regex": "$searchData"}},
                 {"$reduce": 
                   {"input": "$tags",
                    "initialValue": false,
                    "in": 
                     {"$or": 
                       ["$value",
                         {"$regexMatch": 
                           {"input": "$this.name", "regex": "$searchData"}}]}}}]}},
           {"case": {"$eq": ["$searchType", "name"]},
            "then": 
             {"$regexMatch": {"input": "$name", "regex": "$searchData"}}},
           {"case": {"$eq": ["$searchType", "company"]},
            "then": 
             {"$regexMatch": {"input": "$company", "regex": "$searchData"}}},
           {"case": {"$eq": ["$searchType", "tags"]},
            "then": 
             {"$reduce": 
               {"input": "$tags",
                "initialValue": false,
                "in": 
                 {"$or": 
                   ["$value",
                     {"$regexMatch": 
                       {"input": "$this.name", "regex": "$searchData"}}]}}}}],
        "default": true}}}},
     {"$unset": ["searchData", "searchType"]}])