1.只查询需要的字段
Criteria criteria = new Criteria();
criteria.and("companyId").is(companyId).and("evaluate").is(0).and("isDelete").is(0);
BasicDBObject fieldsObject=new BasicDBObject();
//放入需要的字段
fieldsObject.put("_id", 1);
fieldsObject.put("primaryDept",1);
fieldsObject.put("primarygrade",1);
Query query = new BasicQuery(criteria.getCriteriaObject(),fieldsObject);
return find(query);
2.模糊查询
criteria.and("value").regex(value);
3.
db.getCollection("logDetail").find(
{ $and :
[
{"orgId" : "e8c2e5d578324972b6022eeb21d10524"},
{"submitType" : 1},
//字段中的字段 $elemMatch
{"logGroup" : {"$elemMatch":{"groupId":"eb43626672104c1a8016e745f3626b22"}}},
{"templateId" : "81d75e8d91ad45e5982ae49a98aef02f"},
{"submitTime" : { $gte : ISODate("2019-10-14 00:00:00.000") }},
{"submitTime" : { $lte : ISODate("2019-10-14 20:00:00.000") }}
]
})
.limit(1000)
.skip(0)