mongo 关联查询

weixin_43833540

于 2024-05-06 11:10:01 发布

阅读量164

点赞数 1

分类专栏：工作中遇到的MongoDB问题文章标签： mongodb spring boot java

本文链接：https://blog.csdn.net/weixin_43833540/article/details/138487670

版权

工作中遇到的MongoDB问题专栏收录该内容

7 篇文章 0 订阅

订阅专栏

mongodb中有两个集合 collection1 和 collection2 ,通过device_id实现关联查询

 LookupOperation lookupOperation = LookupOperation.newLookup()
        .from("collection2")
        .localField("device_id")
        .foreignField("device_id")
        .as("base_data");
    Criteria unitCriteria = Criteria.where("base_data.unit").is(unit);
    Aggregation aggregation = Aggregation.newAggregation(lookupOperation, match(unitCriteria));
    AggregationResults<Data> results = mongoTemplate.aggregate(aggregation, "collection1", Data.class);
    return results.getMappedResults();

使用List来创建聚合操作

List<AggregationOperation> operations = new ArrayList<>();
 LookupOperation lookupOperation = LookupOperation.newLookup()
        .from("collection2")
        .localField("device_id")
        .foreignField("device_id")
        .as("base_data");
Criteria unitCriteria = Criteria.where("base_data.unit").is(unit);
operations.add(lookupOperation);
operations.add(Aggregation.match(unitCriteria));
Aggregation aggregation = Aggregation.newAggregation(operations);