巢聚集搜索请求
本文关键字:请求 搜索 聚集 | 更新日期: 2023-09-27 18:09:03
我试图通过Nest使用Elasticsearch聚合。首先,我在postman中创建请求,并对其进行测试。当我看到它们正在工作时,我试图通过Nest创建。但是我不能在nest中创建这个请求:
{
"size":0,
"query":{
"filtered":{
"filter":{
"term":{ "operationCode":"logincomplete"}
}
}
},
"aggregations" : {
"operations": {
"terms": {
"field": "operationCode"
},
"aggs": {
"login_count" : { "sum" : { "field" : "adet" } }
}
}
}
}
当前的文档并没有过多地介绍Nest中的聚合。所以我被困住了。到目前为止,我已经试过了:
var filterResults = client.Search<MCAOnlineExtRT>(s => s
.Size(0)
.Filter(q => q
.Term(p => p.OperationCode, "logincomplete"))
.Aggregations(a => a.Sum("login_count", t => t.Field(x => x.Adet)))
);
谢谢!
试试这个:
var results = client.Search<MCAOnlineExtRT>(s => s
.Size(0)
.Query(q => q
.Filtered(f => f
.Filter(ff => ff
.Term(o => o.OperationCode, "logincomplete"))))
.Aggregations(a => a
.Terms("operations", t => t.Field(o => o.OperationCode)
.Aggregations(aa => aa
.Sum("login_count", ss => ss.Field(o => o.Adet))))));
这将产生:
{
"size": 0,
"aggs": {
"operations": {
"terms": {
"field": "operationCode"
},
"aggs": {
"login_count": {
"sum": {
"field": "adet"
}
}
}
}
},
"query": {
"filtered": {
"filter": {
"term": {
"operationCode": "logincomplete"
}
}
}
}
}
注意到fluent API与json DSL的映射是多么的紧密,几乎是一字不差。另外,aggs
是ES中aggregations
的简写形式。