I have 2 collections:
Apartments:
{_id: '1', address: 'Street 1'},
{_id: '2', address: 'Street 2'},
{_id: '3', address: 'Street 3'},
{_id: '4', address: 'Street 4'}
和用户:
{_id: '1', name: 'User 1', favorites: ['1', '3']},
{_id: '2', name: 'User 2', favorites: ['2', '3', '4']},
{_id: '3', name: 'User 3', favorites: []}
我需要做一个查询,返回公寓的详细信息以及它被添加为用户最喜欢的次数计数.所以,大概是这样的:
{_id: '1', address: 'Street 1', favoritesCount: 1},
{_id: '2', address: 'Street 2', favoritesCount: 1},
{_id: '3', address: 'Street 3', favoritesCount: 2},
{_id: '4', address: 'Street 4', favoritesCount: 1}
因此,除了默认公寓的详细信息之外,我还需要有一个"FavoritesCount"字段,该字段查找每个公寓的favorites
个用户数组中包含的计数.