using valueAggregator in fromArray

[dehbini-git]

Hello,
As valueAggregator returns an array, it would be nice if I could pass the array to the parameter "in" of fromArray.
This is my issue:
We have 3 collections : stores, users, events
stores:
{ "_id": ObjectId('store') }

users :
{ "_id": ObjectId('user'), "firstName":..., "lastName":..., "storeId": ObjectId('store') }

events:
{ "_id": ObjectId('event')], "participants": [ { "id": ObjectId('user') } ], "storeId": ObjectId('store') }
What I want?
I want participants in event will be populated with the random numbers of users which belong to the same store.
If we can mix fromArray with valueAggregator, I think it will solve the issue.

[feliixx]

Hi @dehbini-git ,

The ref generator may solve your issue, you can use it like in this example:

https://mongoplayground.net/p/-_ITiQ2Y-vU

would this work for you ?

[dehbini-git]

Hi @feliixx ,
Unfortunately no. I want all participants in events collections have same store Id. But with ref participants are randomly will be from users collection and each user can have different storeId. What I want is all participants will ref to users but belongs to the same store that I think it is possible with Aggregator.