Created
October 5, 2018 01:35
-
-
Save mewben/4f6883f5fd97949c60aae7f699793995 to your computer and use it in GitHub Desktop.
Query with $lookup count
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Site.aggregate() | |
.lookup({ | |
from: 'pages', | |
localField: '_id', | |
foreignField: 'siteID', | |
as: 'pages', | |
}) | |
.addFields({ pageCount: { $size: '$pages' } }) // add pageCount field | |
.project({ pages: 0 }) // exclude pages array | |
.exec(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment