We are migrating to the latest node agent.
We have a collection containing an array of references to another collection and want to display it as Related Data. In the previous agent this was not a problem because we were dealing with a custom collection and we overrode every routes (including smart relationship routes), so we were able to implement the correct query behavior for this particular relationship.
In the new agent though, event though we still have custom collections we are unable to declare this kind of relationship.
Here the order of references is important, that is why a classic One-to-Many relationship is not a suitable answer.
Feature(s) impacted
Smart Relationships
Observed behavior
Cannot display an array of references as Related Data of target Collection.
Expected behavior
I think we should be able to override the relationship query mechanism to fit this use case
Context
- Project name: pinpo-forest-admin-next
- Team name: Operations
- Environment name: Development
- Agent technology: nodejs
- Agent (forest package) name & version: “@forestadmin/agent”: “^1.45.0”,“@forestadmin/datasource-toolkit”: “^1.38.0”,
- Database type: Custom (Translation strategy)