ES条件分页查询与不分页处理

最新推荐文章于 2025-03-13 15:58:13 发布

derlinchen

最新推荐文章于 2025-03-13 15:58:13 发布

阅读量3.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： ElasticSearch 文章标签： elasticsearch

本文链接：https://blog.youkuaiyun.com/derlinchen/article/details/122169858

ElasticSearch 专栏收录该内容

3 篇文章

订阅专栏

该代码片段展示了如何利用Elasticsearch进行分页查询和无分页查询。在分页查询中，根据日期、WMS码和物料码等条件构建BoolQuery，并对创建日期进行范围过滤，按降序排序。无分页查询时，通过CriteriaQuery匹配特定的epc值，获取所有相关数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

分页查询：

if (item.getItem().getEndDate() != null) {
    item.getItem().setEndDate(item.getItem().getEndDate().plusDays(1));
}

Pageable pageable = PageRequest.of(item.getPageNo() - 1, item.getPageSize());
BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
NativeSearchQueryBuilder nativeSearchQueryBuilder = new NativeSearchQueryBuilder();
DrugManageQueryDto searchItem = item.getItem();
if(!StringUtils.isEmpty(searchItem.getWmsCode())) {
    boolQueryBuilder.must(QueryBuilders.matchPhraseQuery("wmsCode", searchItem.getWmsCode()));
}

if(!StringUtils.isEmpty(searchItem.getMaterielCode())) {
    boolQueryBuilder.must(QueryBuilders.matchPhraseQuery("materielCode", searchItem.getMaterielCode()));
}

if(searchItem.getStartDate() != null) {
    long startDate = searchItem.getStartDate().atStartOfDay().toInstant(ZoneOffset.of("+8")).toEpochMilli();
    boolQueryBuilder.must(rangeQuery("createDate").gte(startDate));
}

if(searchItem.getEndDate() != null) {
    long endDate = searchItem.getEndDate().atStartOfDay().toInstant(ZoneOffset.of("+8")).toEpochMilli();
    boolQueryBuilder.must(rangeQuery("createDate").lte(endDate));
}
nativeSearchQueryBuilder.withQuery(boolQueryBuilder).withSort(SortBuilders.fieldSort("createDate").order(SortOrder.DESC));
SearchQuery searchQuery = nativeSearchQueryBuilder.withPageable(pageable).build();
Page<StockOrderPickDetailEs> search = stockOrderPickDetailRepository.search(searchQuery);
PageInfos result;
if(search.getTotalElements() > 0) {
    result = new PageInfos(item.getPageNo(), item.getPageSize(), search.getTotalElements(), search.getTotalPages(), search.getContent());
} else {
    result = new PageInfos(item.getPageNo(), item.getPageSize(), 0, 0, new ArrayList<StockOrderPickDetailEs>());
}
return result;

不分页查询条件下所有的数据：

List<StockDrugCodeEs> result = new ArrayList<>();
Criteria criteria = new Criteria("epc").is(epc);
CriteriaQuery criteriaQuery = new CriteriaQuery(criteria);
CloseableIterator<StockDrugCodeEs> stockDrugCodes = elasticsearchTemplate.stream(criteriaQuery, StockDrugCodeEs.class);

while (stockDrugCodes.hasNext()) {
    result.add(stockDrugCodes.next());
}
return result;