Loading...
 
Skip to main content

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}