Relation naming

The relations between entities are named depending on the look-up direction. As a general rule, the relation name is determined by the entity that contains the data you want to retrieve.

Example: 1

Using the Connection naming diagram below:

If you have queried a result from the Files entity, and you want to retrieve FileContact data from the FileContacts entity, for example a list of Contact IDs, the connection would be named Parties because you are starting in the Files entity and retrieving data from the FileContacts entity.

Conversely, if you used the FileContacts entity to retrieve a list of Contact IDs and wanted file data for each Contact ID in the list, the same connection would be named File because you are starting in the File Contacts entity and retrieving data from the Files entity.

 

 

Example: 2

Using the Connection naming diagram above:

If you have queried a result from the Files entity, and you want to retrieve Contact data from the Contacts entity, for example a list of contact names, two connections would be used:

  • From Files to FileContacts: Parties connection
  • From FileContacts to Contacts: Name connection