Relations Tracker Field
New in Tiki8
Allows to create arbitrary relations between the trackers and other objects in the system.
Relation Relation qualifier. Must be a three-part qualifier containing letters and separated by dots.
This can be anything (just a reference)
Filter URL-encoded list of filters to be applied on object selection.
Unified Index is required for relations fields to work.
See Unified Index
Read-only Only display the incoming relations instead of manipulating them.
Include Invert Include invert relations in the list
This is a working example used at the bug tracker in dev.t.o
Tracker field definition (tiki-admin_tracker_fields.php?trackerId=N):
The previous example produces this field when adding a new tracker item (tiki-view_tracker.php?trackerId=N):
Many to manyIf you want a many to many relation, create a field in each tracker, with the following params
- Relation: put one as normal, and for the other, add a fourth qualifier .invert (ex.: institution.published.work and institution.published.work.invert)
- Filter: set tracker_id=XYZ where XYZ is the ID of the other tracker. Ex: In tracker 19, put tracker_id=20 and in tracker 20, put tracker_id=19
- Read Only: Bot set to no
- Include Invert: Both set to no (the inversion will come from the setting above)
Use case: Projects and SubprojectsOne use case for this type of setup is a projects tracker, in which you define a parent - child relationship among items: which are parent projects of which child projects, while all data reside in the same project tracker.
Even if this setup would probably imply a one to many relationship, the setup is the equivalent as the one indicated in the section above currently named "Many to many", but using the same tracker id in both fields of type "relation" in that same tracker.