elasticsearch - Elastica-多个 bool 查询-子查询

Question

我想使用elastica过滤类别中的多个匹配项:

就像是:

(categories.name =“category-1” AND Categories.level = 0)AND(categories.name =“category-2” AND Categories.level = 1)

"title": "Test Product 1",
"categories": [
  {
    "id": 1,
    "name": "category-1",
    "title": "Category 1",
    "level": 0
  },
  {
    "id": 2,
    "name": "category-2",
    "title": "Category 2",
    "level": 1
  }
]

我努力了:

    $matchQuery = new Query\Match();
    $matchQuery->setField('categories.name', 'category-1');
    //I don't know how to add AND categories.level = 0

    $boolQuery1 = new Bool();
    $boolQuery1->addMust($matchQuery);

    $results = $record->search($boolQuery1)->getResults();

Answer 1

只需将您的 bool(boolean) 子句转换为JSON格式，即可直接传递给elasticsearch查询。我认为这应该有效。

{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "categories",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "categories.name": {
                        "value": "category-1"
                      }
                    }
                  },
                  {
                    "term": {
                      "categories.level": {
                        "value": "0"
                      }
                    }
                  }
                ]
              }
            }
          }
        },
        {
          "nested": {
            "path": "categories",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "categories.name": {
                        "value": "category-2"
                      }
                    }
                  },
                  {
                    "term": {
                      "categories.level": {
                        "value": "1"
                      }
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}