History: PluginTrackerQueryTemplate
Source of version: 6 (current)
Copy to clipboard
{syntax type="markdown" editor="wysiwyg"} # Plugin Tracker Query Template *Introduced in ((Tiki10))* Use this ((wiki plugin)) to generate forms from a tracker. Currently only able to list data, the TrackerQueryTemplate plugin simply obtains data from a tracker and allows an editor the ability to list the tracker data as he sees fit. ## Parameters {pluginmanager plugin="trackerquerytemplate"} ## Features - Supports nesting, where values in settings are from the parent tracker, and those in the body are from the currect tracker - When using `byname="y"` (default), variables are accessed `$field name$` (rendered) and `$\~field name$` (unrendered) - When `byname="n"` , variables are `{$f_id}` (rendered) and `{$\~f_id}` (unrendered) - Filters are in the format `field:value;field:value;field:value;` ## Simple Example Here the: - tracker id = 1 - username field id = 1 - email field id = 2 {CODE(colors="tiki")} {TRACKERQUERYTEMPLATE(tracker="1" orfilters="1:sam;1:bob;")} Username: {$f_1} Email: {$f_2} {TRACKERQUERYTEMPLATE} {CODE} ## Nested Example Here we use the `byname` parameter, which can be more intuitive. **NOTICE** how `$\~username$` comes from tracker named "User Tracker" and not "User Sports Tracker", thus aiding in complex joining scenarios. {CODE(colors="tiki")} {TRACKERQUERYTEMPLATE(tracker="User Tracker" byname="y" orfilters="username:sam;username:bob;")} Username: $username$ Email: $email$ Sports: {TRACKERQUERYTEMPLATE(tracker="User Sports Tracker" byname="y" orfilters="username:$~username$")} *$sport$ {TRACKERQUERYTEMPLATE} {TRACKERQUERYTEMPLATE} {CODE} ## What is nesting? *Nesting* is when an object is embedded in the same type of object, a visual: - root - nested in root - nested in previous nested or in the case of TrackerQueryTemplate nested 2 times: {CODE(colors="tiki")} {TRACKERQUERYTEMPLATE()} {TRACKERQUERYTEMPLATE()} {TRACKERQUERYTEMPLATE()}{TRACKERQUERYTEMPLATE} {TRACKERQUERYTEMPLATE} {TRACKERQUERYTEMPLATE} {CODE}