ES: 分页查询

//查询100条需要更新的project信息
    public List<Project> getTopOutdatedProjectFromES(int size) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String str1 = "2020-1-1 0:0:0";
        Date time1 = null, time2 = null;
        try {
            time1 = sdf.parse(str1);
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(new Date());
            calendar.add(Calendar.MINUTE, -120);
            time2=calendar.getTime();

        } catch (Exception ex) {
            log.info(ex.getMessage());
        }

        BoolQueryBuilder bqr1=QueryBuilders.boolQuery()
                .must(QueryBuilders.existsQuery("projectMemberUpdatingTime"))
                .must(QueryBuilders.rangeQuery("projectMemberUpdatingTime").from(time1).to(time2));

        BoolQueryBuilder bqr2=QueryBuilders.boolQuery()
                .mustNot(QueryBuilders.existsQuery("projectMemberUpdatingTime"));

        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
        boolQueryBuilder.should(bqr1);
        boolQueryBuilder.should(bqr2);

        QueryBuilder queryBuilder = QueryBuilders.boolQuery()
                .mustNot(QueryBuilders.termQuery(DEL_FLAG, true))
                .must(QueryBuilders.existsQuery("deptInfoListMap"))
                .must(boolQueryBuilder)
                ;


        PageRequest page = new PageRequest(0, size);
        List<Project> projects = Lists.newArrayList(projectRepository.search(queryBuilder, page));
        return projects;

    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值