This section contains several examples of how to create a Linked Entities record for a pivot grid in the Aptify Desktop client or a pivot grid in the Aptify web interface (as of Aptify 5.5.4) for a number of different scenarios:
...
| Anchor | ||||
|---|---|---|---|---|
|
An Aptify pivot table or pivot grid can include sub type data for the current entity. For example, as shown in, you can include Person Functions data (that is, the set of functions that are assigned to a person on the Persons record's Functions tab) in the pivot table or pivot grid.
In this case, the linked entity is PersonFunctions, and its PersonID field links to the Persons entity's ID field.
...
Certain entities, such as Topic Codes or Contact Logs, link to any entity using a Links entity (such as Topic Code Links or Contact Log Links). In this case, you also need to define a result constraint to filter the records in the linked entity to return the appropriate set of records.
For example, the figure below illustrates the Linked Entities record's General tab to add Topic Code Links data to a Persons pivot table or pivot grid.
In this case, the Topic Code Links entity can link to other entities in the system other than Persons (such as Companies, Products, etc.). Therefore, this record needs a Result Constraint so that it returns only records related to the Persons entity. See the following figure for the result constraint clause applicable to this situation.
...
For example, if you want to add Contact Log or Topic Code data to a Persons pivot table or pivot grid, you need two Linked Entities records. The first record joins in the Contact Log Links or Topic Code Links entity (with an applicable Result Constraint, see Linked Entity That Requires a Constraint for details). The second record joins in the Contact Log or Topic Codes entity using the Links entity as its join view.
...