mongoDB projection 指定字段返回

佚名 6年前 (2019-05-09) 随笔 1420人围观抢沙发百度已收录

java spring

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

Query query = new Query();
Criteria criteriaSn = Criteria.where("sn").is(sn);
Criteria criteriaTime = Criteria.where("createTime").gte(timeBegin).lte(timeEnd);
query.addCriteria(criteriaSn);
query.addCriteria(criteriaTime);
//指定返回字段
query.fields().include("sLat");
query.fields().include("sLon");
query.fields().include("GLat");
query.fields().include("GLon");
query.fields().include("createTime");

System.out.println(query.toString());
//query.addCriteria(criteriaGLon.orOperator(criteriaSLon));
//正序
query.with(new Sort(new Order(Direction.ASC, "createTime")));

List<DeviceData> list =  mongoTemplate.find(query, DeviceData.class,"deviceData");