主页 / 问题 / 1218508
Accepted
nicolaa
Asked:2021-12-14 17:52:24 +0000 UTC2021-12-14 17:52:24 +0000 UTC

如何使用 AND 运算符检查文档中是否存在字段

  • 772

有一个常规搜索，我们正在寻找category_id特征的存在fields.id

"query" => [
  "bool" => [
    "must" => [
      "match" => [
        "category_id" => $category_id
      ], [
        "exists" => [ 
          "field" => "fields.$id"
        ]
      ]
    ]
  ]
]

搜索工作，任务是再添加一个检查特性的存在fields.id，但为了让它有一个操作符И，也就是说，你需要得到所有的产品，其中：

类别= 1
有一个特征id = 1
或 有一个特征id =2

在文档中，我发现了选择运算符的可能性，仅适用于match

"match" => [
  "message" => [
    "query": "this is a test",
    "operator": "or"
  ]
]

是否有类似的解决方案exists

elasticsearch

1 个回答

  1. Best Answer

    你只需要使用“应该”： https ://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

    "query" => [
  "bool" => [
    "must" => [
      "match" => [
        "category_id" => $category_id
      ]
    ],
    "should" => [
      [
        "exists" => [ 
          "field" => "fields.$id1"
        ]
      ],
      [
        "exists" => [ 
          "field" => "fields.$id2"
        ]
      ],
    ]
  ]
]
    • 1

相关问题