How can I create a reference based on multiple foreign fields?

[tomerh2001]

I have the following mongodb query in my code:

await ActivityPlatformModel.find({
	activityId: context.activity._id,
	platformId: context.platform.id,
});

It is basically redundant since I can use Ref and spare myself the manual query - so I tried just that, I created the following class:

@plugin(autoPopulate)
export class ActivityPlatformReference {
	@prop({
		ref: () => ActivityPlatform,
		localField: 'activityId',
		foreignField: '_id',
		autopopulate: true,
	})
		platform?: ActivityPlatform[];

	@prop({type: () => Types.ObjectId})
		activityId!: Types.ObjectId;

	@prop({type: () => String})
		platformId!: PlatformId;
}

But I can't seem to find a way to specify that I need both activityId and platformId as my localFields / how to specify the matching foreign fields.

How does one do multi-field references in Mongoose/Typegoose?

[hasezoey]

i have not personally needed to do this, but you might wanna look into the match option and read Populate Virtuals: The Match Option

[tomerh2001]

I'm sure I'm not the first that needs a multi key reference...

[hasezoey]

you are not the first in the mongoose space, but in typegoose you are the first who at least asked. and i personally have not needed to use that yet.