la-onlinepmt-orders-query

gistfile1.txt

[
  {
    $match: {
      status: "paid",
    }
  },
  
  {
    $lookup: {
      from: "orders",
      localField: "refId",
      foreignField: "_id",
      as: "order"
    }
  },
  {
    $unwind: {
      path: "$order",
      preserveNullAndEmptyArrays: false
    }
  },
  {
     $project: {
      paymentAmt: "$amount",
      orderId: "$order.orderId",
      paymentId: "$paymentId",
      paymentDate: "$updatedAt"
     }
  }
  ]