Elasticsearch v2.3.5中的过滤器和多_匹配查询

Question

我不熟悉Elasticsearch和Nest，请原谅我的无知。我想在Elasticsearch v2.3.5中使用过滤器和multi\u匹配查询，但到目前为止，我还无法解决这个问题。我想，一旦我把它用于Elasticsearch，我应该能够将它映射到Nest。

以下是我的JSON数据结构：

{
   "contentID":1,
   "categoryID":0,
   "title":"...",
   "description":"...",
   "contentHtml":"...",
   "version":2,
   "parentContentID":0,
   "displayOrder":0,
   "freshdeskID":0,
   "isDraft":false,
   "isCommentingEnabled":false,
   "isArticle":false,
   "grandParentContentID":0,
   "isAnyParentDraft":false
}

下面是我的工作搜索查询（没有任何过滤器）：

POST contents/supportitem/_search?pretty=true
{
  "size": 150,
  "highlight": {
    "fields": {
      "contentHtml": {
        "fragment_size": 245
      }
    }
  },
  "_source": {
    "include": [
      "title",
      "contentID",
      "description",
      "thumbnailUrl",
      "isDraft",
      "isAnyParentDraft",
      "grandParentContentID"
    ]
  },"query": {
    "multi_match": {
      "type": "cross_fields",
      "query": "query typed by user",
      "tie_breaker": 0.3,
      "fields": [
        "title^1.1",
        "additionalContents^1.2",
        "contentHtml^1"
      ]
    }
  }
}

我只想在搜索结果中向用户显示这些记录，其中：

grandParentContentID != 0 and
isDraft != false and
isAnyParentDraft != false

我尝试了不同的查询，但我不知道如何写这个。

两个不起作用的查询包括：

POST contents/supportitem/_search?pretty=true
{
  "size": 150,
  "highlight": {
    "fields": {
      "contentHtml": {
        "fragment_size": 245
      }
    }
  },
  "_source": {
    "include": [
      "title",
      "contentID",
      "description",
      "thumbnailUrl",
      "isDraft",
      "isAnyParentDraft",
      "grandParentContentID"
    ]
  },"query": {
    "multi_match": {
      "type": "cross_fields",
      "query": "Tile map server resources",
      "tie_breaker": 0.3,
      "fields": [
        "title^1.1",
        "additionalContents^1.2",
        "contentHtml^1"
      ]
    },"filtered": {
      "filter": {
        "bool": {
          "term": {
            "isAnyParentDraft": "false"
          }
        }
      }
    }
  }
}


POST contents/supportitem/_search?pretty=true
{
  "size": 150,
  "highlight": {
    "fields": {
      "contentHtml": {
        "fragment_size": 245
      }
    }
  },
  "_source": {
    "include": [
      "title",
      "contentID",
      "description",
      "thumbnailUrl",
      "isDraft",
      "isAnyParentDraft",
      "grandParentContentID"
    ]
  },"query": {
    "multi_match": {
      "type": "cross_fields",
      "query": "Tile map server resources",
      "tie_breaker": 0.3,
      "fields": [
        "title^1.1",
        "additionalContents^1.2",
        "contentHtml^1"
      ]
    },"filtered": {
      "query": {
        "bool": {
          "must": [
            {
              "field": {"isAnyParentDraft": "false"}
            }
          ]
        }
      }
    }
  }
}

我得到“无法解析搜索源。需要字段名，但得到了[START\u OBJECT]”

我已经做到了，但我不知道如何添加更多的过滤器：

POST contents/supportitem/_search?pretty=true
{
  "size": 150,
  "highlight": {
    "fields": {
      "contentHtml": {
        "fragment_size": 245
      }
    }
  },
  "_source": {
    "include": [
      "title",
      "contentID",
      "description",
      "thumbnailUrl",
      "isDraft",
      "isAnyParentDraft",
      "grandParentContentID"
    ]
  },
  "query": {
    "filtered": {
      "query": {
        "multi_match": {
          "type": "cross_fields",
          "query": "deleted",
          "tie_breaker": 0.3,
          "fields": [
            "title^1.1",
            "additionalContents^1.2",
            "contentHtml^1"
          ]
        }
      },
      "filter": {
        "and": {
          "filters": [
            {
              "term": {
                "isAnyParentDraft": "false"
              }
            }
          ]
        }
      }
    }
  }
}

我提出以下问题：

带有multi_match和bool的ElasticSearch-只有一个过滤器

Elasticsearch：multi_match过滤器没有效果

Answer 1

很好的开始，你就快到了：

POST contents/supportitem/_search?pretty=true
{
  "size": 150,
  "highlight": {
    "fields": {
      "contentHtml": {
        "fragment_size": 245
      }
    }
  },
  "_source": {
    "include": [
      "title",
      "contentID",
      "description",
      "thumbnailUrl",
      "isDraft",
      "isAnyParentDraft",
      "grandParentContentID"
    ]
  },
  "query": {
    "bool": {
      "must": {
        "multi_match": {
          "type": "cross_fields",
          "query": "deleted",
          "tie_breaker": 0.3,
          "fields": [
            "title^1.1",
            "additionalContents^1.2",
            "contentHtml^1"
          ]
        }
      },
      "must_not": [
         {
           "term": {
             "isAnyParentDraft": "false"
           }
         },
         {
           "term": {
             "isDraft": "false"
           }
         },
         {
           "term": {
             "grandParentContentID": 0
           }
         }
      ]
    }
  }
}