如何在mongoose中连接两个集合

Question

我实际上从很长一段时间以来一直在努力解决这个问题。

我有一个sql查询

select * from posts where post_uploader='$user_id'或post_uploader in(select follow_user_id from follow where follow_follower_id='$user_id') order by updated_at

谁能告诉我如何做同样的事情与mongo db?

我试图这样做，但我在LocalField得到错误。它要求我传递对象的字符串

postModel.aggregate ([{$查找:{来自:"follow"localField: req.user.id,foreignField:"follow_follower_id":"follow"｝}])

Answer 1

我猜foreignField的正确字段是"_id">

postModel.aggregate([
{ 
$lookup: 
{ 
from: "follow", 
localField: req.user.id, 
foreignField: "_id", 
as: "follow" 
} 
}])

但是你的问题没有足够的信息