Activity links sub-object on models

•
Version: 8.5
• 1 minute to read
 • 1 minute to read

Appointments, documents, sales can link to each other

The system uses the relation table (originally used only for person/contact relations).

This replaced the old single-value DocumentLink property that Appointment and Sale used to have before SuperOffice 6.

The system uses the relation table to allow many-to-many links between all activities.

Appointment link -screenshot

This appointment is saved with appointment_id = 24

x

To find all the links from this appointment:

select * from relations where source_table=9 and source_record=24

x

These links are all defined by reldef_id = 8 (appointment), 9 (document), and 10 (sale), which looks like this:

Select * from relationdefinition

x

Note

A relationship definition can apply to more than one table.

In this case, the link can be to appointments, documents, or sales:

Select * from relationtarget where reldef_id in (8, 9, 10)

x

To summarize in diagram form:

x

See also