Elasticsearch如何用条件排序-Java 学习之路

在我的ElasticSearch（2.x）上，我有这样的文档：

{
    "title": "A good title",
    "formats": [{
        "name": "pdf",
        "prices": [{
            "price": 11.99,
            "currency": "EUR"
        }, {
            "price": 18.99,
            "currency": "AUD"
        }]
    }]
}

我想通过 formats.prices.price 对文档进行排序，但仅限 formats.prices.currency === 'EUR'

我尝试在 formats.prices 上执行嵌套字段，然后运行此查询：

{
  "query": {
    "filtered": {
      "query": {
        "and": [
          {
            "match_all": {}
          }
        ]
      }
    }
  },
  "sort": {
    "formats.prices.price": {
      "order": "desc",
      "nested_path": "formats.prices",
      "nested_filter": {
        "term": {
          "currency": "EUR"
        }
      }
    }
  }
}

但遗憾的是我无法获得正确的订单 .

更新：映射的相关部分：

"formats": {
        "properties": {
          "name": {
            "type": "string"
          },
          "prices": {
            "type": "nested",
            "include_in_parent": true,
            "properties": {
              "currency": {
                "type": "string"
              },
              "price": {
                "type": "double"
              }
            }
          }
        }
      },

1 回答

我希望这能解决你的问题

{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "formats.prices",
            "filter": {
              "match": {
                "formats.prices.currency": "EUR"
              }
            }
          }
        }
      ]
    }
  },
  "from": 0,
  "size": 50,
  "sort": [
    {
      "formats.prices.price": {
        "order": "asc",
        "nested_path": "formats.prices",
        "nested_filter": {
          "match": {
            "formats.prices.currency": "EUR"
          }
        }
      }
    }
  ]
}

回复于 2024-05-01T18:43:12+08:00

Elasticsearch如何用条件排序

1 回答

相关问题