Loading...
 

Relations Tracker Field


New in Tiki8

Allows to create arbitrary relations between the trackers and other objects in the system. See also Items List and Item Link Tracker Fields

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. (see the list below)

ex.: tracker_id=5&object_type=trackeritem

tracker_id=5 is to filter in tracker #5
object_type=trackeritem is to only get tracker items (and not tracker fields)

Unified Index is required for relations fields to work.
See Search and List from Unified Index


Read-only Only display the incoming relations instead of manipulating them.

Include Invert Include invert relations in the list

Notes

When the result show several related items they will be ordered by itemId asc.

Example

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):


Note: The pagination setting will change the way the field is displayed. If the number of possible relations is higher than the "Object selector threshold" parameter that can be found at tiki-admin.php?page=look#contentadmin_look-3. If the field displays more that the "Object selector threshold" value then it will change for a Search input field.

Filtering valid parameters

parameterUsagenotes
tracker_idtracker_id=11
object_typeobject_type=trackeritem
tracker_statustracker_status=o the parameter accept one argument (=op doesn’t work)
.........


Sample: tracker_id=11&object_type=trackeritem&tracker_status=o

Many to many

If 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: Both set to no
  • Include Invert: Both set to no (the inversion will come from the setting above)
  • Force Refresh: should be set to on if you are using Mathematical Calculation Tracker Field which could impact.

Use case: Projects and Subprojects

One 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.


Related:

doc.tiki.org

Get Started

Admin Guide User Guide

Keywords

Keywords serve as "hubs" for navigation within the Tiki documentation. They correspond to development keywords (bug reports and feature requests):

Accessibility (WAI and 508)
Accounting
Articles and Submissions
Backlinks
Banners
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Link Cache
Calendar
Category
Chat
Clean URLs
Comments
Communication Center
Compression (gzip)
Contacts (Address Book)
Contact us
Content Templates
Contribution
Cookie
Copyright
Credit
Custom Home and Group Home Page
Date and Time
Debugger Console
Directory of hyperlinks
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
Draw
Dynamic Content
Dynamic Variable
External Authentication
FAQ
Featured links
File Gallery
Forum
Friendship Network (Community)
Gmap Google maps
Groups
Hotword
HTML Page
i18n (Multilingual, l10n)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
Kaltura video management
Karma
Live Support
Login
Logs (system & action)
Look and Feel
Mail-in
Map with Mapserver
Menu
Meta Elements
Mobile Tiki and Voice Tiki
Module
MultiTiki
MyTiki
Newsletter
Notepad
Payment
Performance Speed / Load
Permissions
Platform independence (Linux-Apache, Windows/IIS, Mac, BSD)
Polls
Profiles
Profile Manager
Report
Toolbar
Quiz
Rating
Feeds
Score
Search engine optimization
Search
Search and Replace
Security
Semantic links
Shadowbox
Shadow Layers
Share
Shopping cart
Shoutbox
Slideshow
Smiley
Social Networks
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Stats
Surveys
Tags
Task
Tell a Friend, alert + Social Bookmarking
TikiTests
Theme CSS & Smarty
Tiki Manager
Trackers
Transitions
User Administration including registration and banning
User Files
User Menu
Watch
WebDAV
Webmail
Web Services
Wiki History, page rename, etc
Wiki Syntax
Wiki structure (book and table of content)
Workspace
WSOD
WYSIWYCA
WYSIWYG
XMLRPC

Tiki Newsletter

Delivered fresh to your email inbox!
Newsletter subscribe icon
Don't miss major announcements and other news!
Contribute to Tiki