代码之家 › 专栏 › 技术社区 › Woppi

如何在mongodb中查找正在分组的聚合集合?

aggregation-framework mongodb-query mongodb

Woppi · 技术社区 · 6 年前

由于某些原因,我无法从聚合查询的另一个集合中检索作者名称。

db.getCollection('books').aggregate([
{
  $match: {
  authorId: { $nin: [ObjectId('5b9a008575c50f1e6b02b27b'), ObjectId('5ba0fb3275c50f1e6b02b2f5'), ObjectId('5bc058b6ae9a2a4d6df330b1')]},
  isBorrowed: { $in: [null, false] },
  status: 'ACTIVE',
},
},
{
    $lookup: {
     from: "authors",
     localField: "authorId", // key of author id in "books" collection
     foreignField: "_id", // key of author id in "authors" collection
     as: "bookAuthor",   
    }
},
{
  $group: {
    _id: {
        author: '$authorId',    
    },
    totalSalePrice: {
      $sum: '$sale.amount',
    },
  },
},
{
  $project: {
      author: '$_id.author',
      totalSalePrice: '$totalSalePrice',    
      authorName: '$bookAuthor.name', // I can't make this appear  
      _id: 0,
  },
},
{ $sort: { totalSalePrice: -1 } },

2 回复 | 直到 6 年前

Ashh 6 年前

事实上,你已经失去了信心 bookAuthor $group 阶段你必须使用 $first 我想在下个月拿到它 $project 阶段

{ "$group": {
  "_id": { "author": "$authorId" },
  "totalSalePrice": { "$sum": "$sale.amount" },
  "authorName": { "$first": "$bookAuthor" }
}},
{ "$project": {
  "author": "$_id.author",
  "totalSalePrice": "$totalSalePrice",    
  "authorName": { "$arrayElemAt": ["$bookAuthor.name", 0] }
  "_id": 0,
}}

mickl 6 年前

这里缺少两件事:你需要 $unwind 转化 bookAuthor $group

db.getCollection('books').aggregate([
    {
    $match: {
        authorId: { $nin: [ObjectId('5b9a008575c50f1e6b02b27b'), ObjectId('5ba0fb3275c50f1e6b02b2f5'), ObjectId('5bc058b6ae9a2a4d6df330b1')]},
        isBorrowed: { $in: [null, false] },
        status: 'ACTIVE',
        },
    },
    {
        $lookup: {
            from: "authors",
            localField: "authorId", 
            foreignField: "_id", 
            as: "bookAuthor", // this will be an array   
        }
    },
    {
        $unwind: "$bookAuthor"
    },
    {
        $group: {
            _id: {
                author: '$authorId',    
            },
            bookAuthor: { $first: "$bookAuthor" },
            totalSalePrice: {
                $sum: '$sale.amount',
            },
        },
    },
    {
        $project: {
            author: '$_id.author',
            totalSalePrice: '$totalSalePrice',    
            authorName: '$bookAuthor.name',  
            _id: 0,
        },
    },
    { $sort: { totalSalePrice: -1 } },
])

推荐文章

Tom McLean · 如何使用证书管理器制作的证书在AWS上创建到mongodb实例的TLS/SSL连接?健康检查失败

7 月前

hasratyan · Next.js 15 API路由-动态路由中的无效GET导出错误[id]

7 月前

RoadieRich · MongoDB:无法创建<type>的实例,因为它是一个抽象类

7 月前

Plup · 连接失败时,PyMongo异步客户端未引发异常

8 月前

Yusuf Damista · 将mongodb节点代码转换为php

8 月前

ian12_ · 客户端未定义,无法使用mongodb驱动程序连接到数据库

12 月前

Sachin · Spring Session响应MongoDB-如何处理属性

1 年前

Isus Ramzy · 如何在Vercel中使用“pymongo”和“flask”

1 年前

weareblahs · 由于BSONError,路径(pathName)处的值(数组)转换为ObjectId失败

1 年前

sachin p · MongoDB docker的默认用户和密码

1 年前