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

Generate a form from tracker data
Introduced in Tiki 10. Required parameters are in bold.
Go to the source code
Preferences required: feature_trackers, wikiplugin_trackerquerytemplate

Parameters Accepted Values Description Default Since
(body of plugin) Wiki Syntax, with variables from tracker query.
tracker text The name of the tracker to be queried, or if byname="n", the tracker ID. 10.0
andfilters text Apply "and" filters to fields. Format: field:value;field:value;field:value, where field may be the field name or ID depending on the setting for the byname parameter. 10.0
likefilters text Apply "like" filters to fields. Format: field:value;field:value;field:value, where field may be the field name or ID depending on the setting for the byname parameter. 10.0
orfilters text Apply "or" filters to fields. Format: field:value;field:value;field:value, where field may be the field name or ID depending on the setting for the byname parameter. 10.0
debug (blank)
y
n		 Turn tracker query debug on (off by default). 10.0
getlast (blank)
y
n		 Retrieve only the last item from the tracker. 10.0
render (blank)
y
n		 Render as needed for trackers (default). y 10.0
byname (blank)
y
n		 Use the tracker name instead of tracker ID in the tracker parameter. Also use the field name instead of field ID in the filter parameters. Set to Yes (y) to use names (default) or No (n) to use IDs. y 10.0
itemid digits Item id of tracker item 10.0
itemids digits
separator: ,		 Item id of tracker items, separated with comma 11.0

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
Copy to clipboard
{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.

Copy to clipboard
{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:

Copy to clipboard
{TRACKERQUERYTEMPLATE()}
	{TRACKERQUERYTEMPLATE()}
		{TRACKERQUERYTEMPLATE()}{TRACKERQUERYTEMPLATE}
	{TRACKERQUERYTEMPLATE}
{TRACKERQUERYTEMPLATE}