如何查找一个字段的值与另一个字段的值相匹配的所有文档 [英] How to find all documents where the value of one field matches that of another

问题描述

我在文档中有两个字段，具有以下映射：

I have two fields within a document with the following mapping:

"field_a": {
    "type": "float"
},
"field_b": {
    "type": "float"
}

如何查找 field_a 的值与 field_b ？这是可能的脚本禁用？

How can I find all documents where the value for field_a matches that of field_b? Is this possible with scripting disabled?

推荐答案

基本上你需要一个脚本来做 - 即使脚本被禁用，这可能会工作因为lucene表达式是完全沙盒的：

Basically you need a script to do it -- this may work even if scripting is disabled because the lucene expressions are fully sandboxed:

GET /index/_search
{
  "query": {
    "filtered": {
      "query": {
        "match_all": {}
      },
      "filter": {
        "bool": {
          "must": [
            {
              "script": {
                "lang": "expression",
                "script": "doc['field_a'].value == doc['field_b'].value"
              }
            }
          ]
        }
      }
    }
  }
}

这篇关于如何查找一个字段的值与另一个字段的值相匹配的所有文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！