I’m new to AppFarm and I’m struggling a bit with the data layer. I have an object class that represent a many-to-many relation between two objects X and Y. And when I want to render all Y’s for the X’s I have I get duplicate Y’s when they are connected to more than one of the X’s.
How can I ask AppFarm to only return unique values? Is this possible?
So, having s many-to-many relationship, and you want unique entries of one of the sides, you may do as follows.
Lets use an example:
Project Participant (many to many between
Project Participants is a datasource in your App, holding all participants for all projects, and you want to list unique projects:
- Add a datasource (suggested naming)
Projects (unique), Runtime only with cardinality Many
- Do a read objects with filter
Projects (unique).ID exists in Project Participants.Project
Projects (unique) now holds all unique projects.