ElasticSearch：使用Nest从动态条件列表中创建应该查询

gt0wga4j 于 2022-10-06 发布在 ElasticSearch

关注(0)|答案(1)|浏览(170)

使用ElasticSearch 7.6，我想要找到区域列表中的所有点。还有几个其他过滤条件被添加到QueryContainerDescriptor列表中并应用于最终搜索。

var queries = new List<Func<QueryContainerDescriptor<MySearchableObject>, QueryContainer>>();

此示例适用于一个区域，其中坐标是一个词典

foreach (var area in areas)
{
    var pointsList = area.Coordinates.Values.Select(p => new GeoLocation(p.Latitude, p.Longitude)).ToList();

    queries.Add(sqs => sqs
        .GeoPolygon(r => r
            .Field(f => f.Position)
            .ValidationMethod(GeoValidationMethod.Strict)
            .Points(pointsList)));
}

还有这个：

queries.Add(sqs => sqs.Bool(b=>b.Should(bs => GeoPolygonShouldQuery(bs, area))));

private static QueryContainer GeoPolygonShouldQuery(QueryContainerDescriptor<MySearchableObject> bs, FilterArea area)
{
     return bs
    .GeoPolygon(r => r
        .Field(f => f.Position)
        .ValidationMethod(GeoValidationMethod.Strict)
        .Points(area.Coordinates.Values.Select(p => new GeoLocation(p.Latitude, p.Longitude))));
}

我该如何为列表中的每个区域添加一个HASH子句呢？

类似于此：

queries.Add(sqs => sqs.Bool(b => b.Should(
                bs => bs.GeoPolygon(r => r.Field(f => f.Position)
                    .Points(areas.ElementAt(0).Coordinates.Values.Select(p => new GeoLocation(p.Latitude, p.Longitude)).ToList())),
                bs => bs.GeoPolygon(r => r.Field(f => f.Position)
                    .Points(areas.ElementAt(1).Coordinates.Values.Select(p => new GeoLocation(p.Latitude, p.Longitude)).ToList()))
                )));

elasticsearch

来源：https://stackoverflow.com/questions/62080400/elasticsearch-create-should-queries-from-a-dynamic-list-of-criterias-with-nest

1条答案

按热度按时间

bakd9h0s1#

经过更多的试验和错误，这似乎解决了问题：

var areas = FindFilterAreas(query.Areas);
queries.Add(sqs => sqs.Bool(b => b.Should(MyQueries(b, areas))));

private static List<Func<QueryContainerDescriptor<SearchableSituation>, QueryContainer>> MyQueries(BoolQueryDescriptor<SearchableSituation> qd, IEnumerable<FilterArea> areas)
{
    List<Func<QueryContainerDescriptor<SearchableSituation>, QueryContainer>> queries = new List<Func<QueryContainerDescriptor<SearchableSituation>, QueryContainer>>();

    foreach (var area in areas)
    {
        var pointsList = area.Coordinates.Values.Select(p => new GeoLocation(p.Latitude, p.Longitude)).ToList();

        queries.Add(sqs => sqs
            .GeoPolygon(r => r
                .Field(f => f.Position)
                .ValidationMethod(GeoValidationMethod.Strict)
                .Points(pointsList))
        );
    }

    return queries;
}

赞(0）回复(0）举报 2022-10-06

我来回答

ElasticSearch：使用Nest从动态条件列表中创建应该查询

1条答案

相关问题

热门标签

最新问答