support for ObjectId based reference search

[SGeri]

If we have a user document in the users collection like the following schema: (example)

{
_id: ObjectId(A)
profile: ObjectId(B)
}

and a profile document in the profiles collection:

{
_id: ObjectId(B)
name: "test"
}

...and I want to make a search in the users collection where we query the user.profile.name field, currently this package does not offer a solution. Are you planning to implement a built-in lookup aggregation pipleine solution for this case? Thanks a lot.

[balazsnemeth]

@NathanAdhitya @paulr113 do you think you can take a look? We also met this limitation.

[NathanAdhitya]

Hi. Unfortunately, for now, document joins on the server are outside of the scope of this project. In such cases, forking and building upon this repository may be desirable.

For such queries, does the ReferenceField family of components not work for your use case?

PS. many of the methods provided by this package can be reused. If you need certain custom behaviour, it is possible to disable a route e.g. list, and then implement/extend your own list route.