I apologize if the title is inaccurate - I'm not quite sure how to articulate this issue. I'm building a social media-type application and want to implement a privacy feature. Right now, I'm trying to only retrieve posts if the creator's profile is not private. The creator is populated in a pre hook.
For example, this works fine (only gets posts where the caption is "hello there!"):
const posts = await Post.find()
// .populate("creator").populate("comments") // this is done in a pre hook
.where("caption").equals("hello there!")
.sort("-createdAt");
I want to do the same thing with the "creator" object instead of the "caption" object. Something like:
const posts = await Post.find()
// .populate("creator").populate("comments") // this is done in a pre hook
.where("creator.private").equals(false)
.sort("-createdAt");