下面只是我的 mongodb 文档的一个例子。和 sum
当从产品文档中选择交易 175
时,我期望 August
中每个交易文档中的产品数量
products
文档中的预期结果
[
{
"_id":"61012014f7416b0a41db7055","name":"MIE","retailPrice":20000,"qtyInTransaction":175
}
]
这是我的文件
products
文档
[
{
"_id":"61012014f7416b0a41db7055","description":"PRODUK BARU",}
]
producutInTransaction
文档
[
{
"_id":"6106a3b1f1bbd62640c7b404","transactionDate":{"$date":"2021-08-01T00:00:00.000Z"},"productsInTransactions":
[
{
"_id":"6106a3cff1bbd62640c7b405","productId":"61012014f7416b0a41db7055"},"qty":100,"price":5000,"description":"asdn"
},{
"_id":"6106a3cff1bbd62640c7b406","qty":50,"description":"asdn"
}
]
},{
"_id":"6106a3b1f1bbd62640c7b4007","productsInTransactions":
[
{
"_id":"6106a3cff1bbd62640c7b407","qty":25,]
}
]
感谢您的帮助,对不起我的英语