mongodb的聚合查询,里面包含枚举类型的查询时, 要转成String再做查询,否则会报:
org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class ...
记录一下.
例如下例中的SearchLogType.USER.toString()
try {
Criteria rightIntervalCR = Criteria.where("time").lt(rightIntervalDate);
Criteria leftIntervalCR = Criteria.where("time").gte(leftIntervalDate);
Criteria onlineCR = Criteria.where("type").is(SearchLogType.USER.toString());//只查询线上问的日志
String[] groupUseFields = {"userid"};
AggregationOperation matchOperation = new MatchOperation(leftIntervalCR.andOperator(onlineCR, rightIntervalCR));
AggregationOperation groupOperation = new GroupOperation(Fields.fields(groupUseFields));
AggregationOperation[] aggregationOperations = new AggregationOperation[2];
aggregationOperations[0] = matchOperation;
aggregationOperations[1] = groupOperation;
Aggregation aggregation = Aggregation.newAggregation(aggregationOperations);
AggregationResults<String> aggregationResults = mongoOperation.aggregate(aggregation, logCollectionName, String.class);
List<String> useridList = aggregationResults.getMappedResults();
if (useridList != null) {
for (String userid : useridList) {
JsonObject useridJsonObject = GsonFactory.getGsonClient().fromJson((String) userid, JsonObject.class);
String useridStr = useridJsonObject.get("_id").getAsString();
}
}
} catch (Exception e) {
e.printStackTrace();
}
转载于:https://my.oschina.net/airship/blog/2252081
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/101353.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...