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

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

{TRACKERQUERYTEMPLATE(tracker="1" orfilters="1:sam;1:bob;")}
Username: {$f_1}
Email: {$f_2}
{TRACKERQUERYTEMPLATE}

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.

{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}

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:

{TRACKERQUERYTEMPLATE()}
	{TRACKERQUERYTEMPLATE()}
		{TRACKERQUERYTEMPLATE()}{TRACKERQUERYTEMPLATE}
	{TRACKERQUERYTEMPLATE}
{TRACKERQUERYTEMPLATE}