Features / Usability

Posted by Rick Sapir / Tiki for Smarties 13 Aug 2014 10:28 GMT-0000 posts: 3665

The

• tiki_trackers — Defines the (unique) trackerId for each tracker.
• tiki_tracker_fields — Defines each field information (e.g., name, options, etc.) for each tracker field. There's a unique fieldId and a references to the trackerId__.
• tiki_tracker_item_fields — Contains the actual value for each tracker field. There are references to the tracker itemId and fieldId.

Instead of creating a SELECT statement, why not simply use one of the existing tracker plugins (TRACKERLIST, TRACKERFILTER, etc.) to extract the required data? You loose all of the permission/security checks when you query the DB directly.

You can also build a pretty tracker and include some basic Smarty syntax (e.g., if .. then... else...) within the page.

HTH,

- Rick | My Tiki Blog | My Tiki UserPage