I have a Mongoose schema in NestJS structured like this:
...
@Prop()
casinoAmount: number;
@Prop()
gameHyperLink: string;
@Prop()
casinoHyperLink: string;
@Prop({ type: Types.ObjectId, ref: 'Game' })
games: Game[];
}
I'm trying to create a query that performs a full "left join", meaning it selects each Provider with all elements from the corresponding games.
If I run a regular query (without using populate), it will simply return all the ObjectID's.
const providers = await this.providerRepository
.find({})
.skip(offset)
.limit(limit)
.exec();
https://i.stack.imgur.com/OKMjH.png
However, when I try to populate the data like this
const providers = await this.providerRepository
.find({})
.populate('games')
.skip(offset)
.limit(limit)
.exec();
https://i.stack.imgur.com/CR3SD.png
The issue is that it only returns a single game object instead of a list containing all the objects. Can anyone explain why this is happening?