Skip to content

Instantly share code, notes, and snippets.

@hrishi7
Created July 4, 2020 13:27
Show Gist options
  • Save hrishi7/4e7a24fa6cd296358a1e0033897039be to your computer and use it in GitHub Desktop.
Save hrishi7/4e7a24fa6cd296358a1e0033897039be to your computer and use it in GitHub Desktop.
let pref = await Preference.aggregate([
{ $sort: { _id: -1 } },
{
$facet: {
user: [
{
$lookup: {
from: User.collection.name,
localField: "user",
foreignField: "_id",
as: "userData",
},
},
{ $unwind: "$userData" },
{
$project: {
// user: 0,
user: "$userData.displayName",
// keyword: 0,
},
},
],
keyword: [
{
$lookup: {
from: Keyword.collection.name,
localField: "keyword",
foreignField: "_id",
as: "keywordData",
},
},
{ $unwind: "$keywordData" },
{
$project: {
// keyword: 0,
keywordData: {
keyword: "$keywordData.keyword",
count: "$keywordData.count",
},
// user: 0,
},
},
],
},
},
]);
res.json(pref);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment