NativeSearchQueryBuilder多条件查询，会覆盖前面的条件

最新推荐文章于 2024-08-20 17:17:09 发布

wsfjsfdxsmz

最新推荐文章于 2024-08-20 17:17:09 发布

阅读量2.4k

点赞数 4

文章标签：数据库

本文链接：https://blog.csdn.net/wssmz/article/details/120086347

版权

NativeSearchQueryBuilder builder = new NativeSearchQueryBuilder()
        .withQuery(QueryBuilders.termQuery("flag", 1))
        .withQuery(QueryBuilders.termQuery("focus", 1))
        .withSort(SortBuilders.fieldSort("createTime").order(SortOrder.DESC));

调用了多个withQuery，通过底层的代码可以看出会覆盖前面withQuery,只保留一个withQuery

正确的方法：

NativeSearchQueryBuilder builder = new NativeSearchQueryBuilder();        builder.withQuery(QueryBuilders.boolQuery().must(QueryBuilders.termQuery("flag", 1)).must(QueryBuilders.termQuery("focus", 1)));
 builder.withSort(SortBuilders.fieldSort("createTime").order(SortOrder.DESC));