Loading...
 
Skip to main content

History: PluginTrackerQueryTemplate

Source of version: 5 (current)

Copy to clipboard
            ! 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}