需要帮助在Nest查询中实现多个Or条件
本文关键字：实现 Or 条件 查询 帮助 Nest | 更新日期: 2023-09-27 18:15:04
我试图在Nest ElasticSearch中实现以下SQL伪代码。
我没有发现任何类似的StackOverflow问题匹配这个问题或在Nest文档。感谢您提供的任何指导。
select *
from curator..published
where accountId = 10
and (
(publishStatusId = 3 and scheduledDT > '2015-09-01')
or
(publishStatusId = 4 and publishedDT > '2015-09-01')
)
我创建了以下ElasticSearch查询，但无法成功地将其转换为Nest语法。
GET curator/published/_search
{
"query": {
"filtered": {
"filter": {
"bool": {
"must": [
{
"term": {
"accountID": 1781
}
}
],
"should": [
{
"bool": {
"must": [
{
"term": {
"publishStatusID": 4
}
},
{
"range": {
"publishedDT": {
"gte": "2015-09-01T00:00:00.000"
}
}
}
]
}
},
{
"bool": {
"must": [
{
"term": {
"publishStatusID": 3
}
},
{
"range": {
"scheduleDT": {
"gte": "2015-09-01T00:00:00.000"
}
}
}
]
}
}
]
}
}
}
}
}
这个嵌套查询通过了语法检查，但是只有最后一个"应该"条件出现在结果ElasticSearch查询中。
var results = this.Client.Count<Data>(c => c
.Query(q => q
.Filtered(f1 => f1
.Filter(f2 => f2
.Bool(b => b
.Must(
f => f.Term(FieldName.AccountID, "10")
)
.Should(s => s
.Bool(b1 => b1
.Must(
f => f.Term(FieldName.PublishStatusID, "3"),
f => f.Range(m => m.OnField(FieldName.ScheduleDT).GreaterOrEquals("2015-09-01"))
)
)
)
.Should(s => s
.Bool(b1 => b1
.Must(
f => f.Term(FieldName.PublishStatusID, "4"),
f => f.Range(m => m.OnField(FieldName.PublishedDT).GreaterOrEquals("2015-09-01"))
)
)
)
)
)
)
)
);
这个Nest查询更好地匹配原始ElasticSearch查询，但在第二个Bool上引发以下错误:错误51 'Nest。FilterContainer'不包含'Bool'的定义，也没有扩展方法'Bool'接受类型为'Nest '的第一个参数。FilterContainer'可以找到(您是否缺少using指令或程序集引用?)
var results = this.Client.Count<Data>(c => c
.Query(q => q
.Filtered(f1 => f1
.Filter(f2 => f2
.Bool(b => b
.Must(
f => f.Term(FieldName.AccountID, AccountID)
)
.Should(s => s
.Bool(b1 => b1
.Must(
f => f.Term(FieldName.PublishStatusID, "3"),
f => f.Range(m => m.OnField(FieldName.ScheduleDT).GreaterOrEquals("2015-09-01"))
)
)
.Bool(b2 => b2
.Must(
f => f.Term(FieldName.PublishStatusID, "4"),
f => f.Range(m => m.OnField(FieldName.PublishedDT).GreaterOrEquals("2015-09-01"))
)
)
)
)
)
)
)
);
您的第一个查询并不遥远，只是传递给第二个Should()的表达式需要传递给第一个Should()的另一个表达式(Should()需要params Func[] filters)。下面是查询(我在这里使用dynamic作为泛型类型):
void Main()
{
var settings = new ConnectionSettings(new Uri("http://localhost:9200"));
var connection = new InMemoryConnection(settings);
var client = new ElasticClient(connection: connection);
var docs = client.Count<dynamic>(c => c
.Query(q => q
.Filtered(f1 => f1
.Filter(f2 => f2
.Bool(b => b
.Must(
f => f.Term(FieldName.AccountID, "10")
)
.Should(s => s
.Bool(b1 => b1
.Must(
f => f.Term(FieldName.PublishStatusID, "3"),
f => f.Range(m => m.OnField(FieldName.ScheduleDT).GreaterOrEquals("2015-09-01"))
)
),
s => s
.Bool(b1 => b1
.Must(
f => f.Term(FieldName.PublishStatusID, "4"),
f => f.Range(m => m.OnField(FieldName.PublishedDT).GreaterOrEquals("2015-09-01"))
)
)
)
)
)
)
)
);
Console.WriteLine(Encoding.UTF8.GetString(docs.RequestInformation.Request));
}
public static class FieldName
{
public static string AccountID = "AccountID";
public static string ScheduleDT = "ScheduleDT";
public static string PublishedDT = "PublishedDT";
public static string PublishStatusID = "PublishStatusID";
}
生产
{
"query": {
"filtered": {
"filter": {
"bool": {
"must": [
{
"term": {
"AccountID": "10"
}
}
],
"should": [
{
"bool": {
"must": [
{
"term": {
"PublishStatusID": "3"
}
},
{
"range": {
"ScheduleDT": {
"gte": "2015-09-01"
}
}
}
]
}
},
{
"bool": {
"must": [
{
"term": {
"PublishStatusID": "4"
}
},
{
"range": {
"PublishedDT": {
"gte": "2015-09-01"
}
}
}
]
}
}
]
}
}
}
}
}
这与上面的查询DSL匹配