ES 查询

目录

• null
• 模糊搜索
• 查询总数
• 参考资料

模糊搜索

模糊搜索，使用WildcardQueryBuilder （使用fuzzy 找不到数据）

BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();

//ES分页从0开始算，但是前端从1开始算。 所以减一
Pageable pageable = PageRequest.of(queryObj.getPageNumber()-1, queryObj.getPageSize());

boolQueryBuilder.must(QueryBuilders.rangeQuery("create_time").gte(queryObj.getBeginCreateDate()));
boolQueryBuilder.must(QueryBuilders.rangeQuery("create_time").lte(queryObj.getEndCreateDate()));



if(null != queryObj.getFailedReason()){//模糊查询
	WildcardQueryBuilder wildcardQuery = QueryBuilders.wildcardQuery("XXXX", "*"+queryObj.getxxxx()+"*");
	boolQueryBuilder.filter(wildcardQuery);
}


NativeSearchQuery nativeSearchQuery = new NativeSearchQueryBuilder()
		.withQuery(boolQueryBuilder)
		.withPageable(pageable)
		.build();

IndexCoordinates indexCoordinates = IndexCoordinates.of(indexName);


SearchHits<XXXXDocument> search = elasticsearchTemplate.search(nativeSearchQuery
		, XXXXDocument.class, indexCoordinates);

pageDTO.setContent(search.getSearchHits().stream()
		.map(searchHit -> searchHit.getContent())
		.collect(Collectors.toList()));
pageDTO.setPageSize(queryObj.getPageSize());
pageDTO.setPageNumber(queryObj.getPageNumber());
		

查询总数

@Autowired
private ElasticsearchOperations elasticsearchOperations;

IndexCoordinates indexCoordinates = IndexCoordinates.of(indexName);
BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
  // 定义查询条件

NativeSearchQuery nativeSearchQueryWithoutPage= new NativeSearchQueryBuilder()
				.withQuery(boolQueryBuilder)
				.build();


long count =  elasticsearchOperations.count(nativeSearchQueryWithoutPage, XXXXDocument.class,indexCoordinates);

参考资料