c# - 如何将特定的Elasticsearch DSL查询转换为嵌套查询？

Question

如何将下面的DSL查询转换为C#NEST查询？

GET project/_search
{
  "size": 0, 
  "aggs": {
  "group_by_projectId": {
      "filter": {
      "terms": {
         "projectId.keyword": ["1", "2", "18"]
       }
    },
    "aggs": {
      "project_tags": {
      "terms": {
        "field": "projectId.keyword",
        "size": 100
     },
      "aggs": {
        "last_process_time": {
          "max": {
            "field": "processedAt"
          }
        }
       }
      }
     }
    }
   }
 }

有人会帮我查询嵌套吗？先感谢您。

Answer 1

我已经将查询转换如下，并且可以正常运行:

_elasticClient.SearchAsync<Project>(s => s
                .Size(0)
                .Aggregations(a => a
                    .Filter("filter_by_projectId", f => f
                        .Filter(ff => ff
                            .Terms(t => t
                                .Field(tf => tf.ProjectId)
                                .Terms(projects
                                    .Select(ps => ps.Id))))
                        .Aggregations(agg => agg
                            .Terms("group_by_projectId", st => st
                                .Field(o => o.ProjectId.Suffix("keyword"))
                                .Size(100)
                                .Aggregations(aa => aa
                                    .Max("last_process_time", sa => sa
                                        .Field(o => o.ProcessedAt))))))));