Loading...
 

PluginList output control block


The OUTPUT control block defines what the output 'template' will be for the results.

Parameters

parameter value example since
downloadable filename.csv downloadable="MyData.csv" 18.0
inline ? n/a
report y/n 20.0? (future)
template file.tpl or built-in template (see below) my.tpl
path/to/template/file/my.tpl
tplwiki wiki page (parsed the same as Smarty tpl) tplwiki="MyTPL"
wiki wiki page (parsed including wiki syntax) wiki="MyTPL"

Built-in templates

name purpose since
carousel display the data in a carousel (slider) 14.0
count just count the number of results 15.0
medialist 13.0
table display the data in a table format


Below the simple Wiki Formatting Within Plugin is discussed as well as the standard/built-in templates, e.g., table, medialist and carousel. For user defined wiki or smarty templates see PluginList advanced output control block.

Basic Wiki Formatting Within Plugin

By placing Wiki syntax directly in the OUTPUT body content, along with the required objects to be displayed, the control block allows a template for each row of output to be constructed within the LIST plugin itself.

In the example below a table is constructed with the table 'header' row placed before the LIST and the table closing characters placed after the LIST. Each row of the table is then created by the LIST plugin with each table cell element generated by the display control block and separated by the usual table separator, i.e., a |

Wiki Output Sample
||Type|Object
{LIST()}
{list max="10"}
    {OUTPUT()}{display name="object_type"}|{display name="object_id"}
    {OUTPUT}
    {ALTERNATE()}This will display if no results are found{ALTERNATE}
{LIST}
||

TypeObject
wiki pageRSS Config
wiki pageRSS Feeds Details
wiki pageSafe Characters in Wiki page names
wiki pageScore vs Karma
wiki pageScreencast
wiki pagescreenshot
wiki pageSearch and replace
wiki pageSearch Details
wiki pageSearch User
wiki pageSearch within files

Table Formatting

A simple built-in templating method can be used by setting the OUTPUT template parameter to table and then using a column control block in the OUTPUT body content to define the individual columns of the table.

Table Column Control

Column Parameters

editable inline 11.0
field field or FORMAT name reference
label text
mode raw
sort field or FORMAT name reference
translatelabel y/n 18.0

Column Mode Parameter

When you use table output with a column generating HTML output (like objectlink and trackerrender formatted values), you should include the mode="raw" in the column specification. In the sample below, the column "title" mode is set to raw as in the format we want to display an objectlink. Other formats are available; see more about it here: PluginList display control block

(Tiki 11+) editable=inline will set the field to be editable inline. Required: "Inline editing (found in trackers)" and column should be set to mode=raw. e.g:

Sample using the default table formatting
{LIST()}
   {filter type="trackeritem"}
   {filter content="water"}
   {OUTPUT(template="table")}
       {column sort="title" label="Title" translatelabel="y" field="title_link" mode="raw"}
       {column label="Description" field="description" }
       {column sort="tracker_field_18" field="event_date" label="Event Date"}
   {OUTPUT}

   {FORMAT(name="title_link")}{display name="title" format="objectlink"}{FORMAT}
   {FORMAT(name="event_date")}{display name="tracker_field_18" format="date"}{FORMAT}
{LIST}

No results for query.


Note that the column controls (within OUTPUT) are converted to a data array sent to the template. The table formatting uses Smarty formatting and provides the same capabilities.

(Tiki 18+) translatelabel="y" will translate the column label provided the translation is known to Tiki.

The use of the FORMAT control blocks allows individual objects to be 'formatted' and then referenced in the various OUTPUT methods - see PluginList format control block for more details.

Download CSV of Table Results

(Tiki 18+) downloadable=filename.csv parameter can be used to add a Download button which generates a CSV file with all data found in the table. Header row is based on the table headers formatted via column mode parameter.

Output formatting with download option
{OUTPUT(template="table" downloadable="Sample file.csv")}
...column specification...
{OUTPUT}

Table formatting with tablesorter

Starting with Tiki15, PluginList can be used with tablesorter. Use a {tablesorter} tag to add the tablesorter parameters. See below, which uses the same syntax as above except for the addition of the tablesorter tag:

Sample with tracker list and calculation
{LIST()}{pagination max="12"}
{filter field="tracker_id" content="17"}
{OUTPUT(template="table")}
{column label="Month" field="month" mode="raw"}
{column label="Started" field="started"}
{column label="Completed" field="completed"}
{column label="Status" field="status"}
{tablesorter server="n" sortable="type:reset" tsortcolumns="type:text|type:none|type:none|type:text" tsfilters="type:nofilter|type:nofilter|type:nofilter|type:dropdown;empty:empty" tstotals="| |type:col;label:Total hours|" tstotaloptions="ignore|ignore| |ignore" tstotalformat="#,###."}
{OUTPUT}
{FORMAT(name="month")}{display name="tracker_field_month" format="objectlink"}{FORMAT}
{FORMAT(name="started")}{display name="tracker_field_started"}{FORMAT}
{FORMAT(name="completed")}{DIV(type="span" class="float-right")}{display name="tracker_field_completed"}{DIV}{FORMAT}
{FORMAT(name="status")}{display name="tracker_field_status" default=""}{FORMAT}
{LIST}


Will produce the following (note that a span and bootstrap class are added to align the numbers as by default tablesorter calculation are numbers aligned right)



Sample adding tablesorter functionality
{LIST()}
   {filter type="trackeritem"}
   {filter content="water"}
   {OUTPUT(template="table")}
       {column sort="title" label="Title" field="title_link" mode="raw"}
       {column label="Description" field="description"}
       {column sort="tracker_field_18" field="event_date" label="Event Date"}
       {tablesorter server="n" sortable="type:reset" tsortcolumns="type:text|type:text|type:digit" tsfilters="type:text|type:dropdown|type:digit" tspaginate="max:10" tscolselect="critical|5|6"}
   {OUTPUT}
   {FORMAT(name="title_link")}{display name="title" format="objectlink"}{FORMAT}
   {FORMAT(name="event_date")}{display name="tracker_field_18" format="date"}{FORMAT}
{LIST}

No results for query.


Please note that in some cases, if you want to use the tsfilters, you will need to take into account an extra column at the beginning for the:

  • status field
  • checkbox to perform actions on the listed items through the PluginListExecute
    you can safely pre-pend, for instance, a "type:nofilter|" at the begining of the parameters of the tsfilter in such cases.

Table: expand table, number of items found, optional title

Starting with Tiki20, PluginList has a few optional parameters that work in conjunction with the table built-in template. Use a {tableparams} tag to add these parameters:

  • allowtableexpansion: for allowing table expansion (a toggle button to allow wide tables to overflow to the right of the content area rather than be scrollable in a limited-width area) (backported to 19.1 and 18.4)
  • shownbitems: to show the number of items found. (backported to 19.1 and 18.4)
  • title: whatever string you use here will be shown above the results table, with tiki syntax. The main purpose of this parameter is to allow for the title not to show when there are no results found. (backported to 19.2 and 18.4)

See usage example below:

Table showing items count and with an expand button
{LIST()}
  {filter content="1" field="tracker_id"}
{OUTPUT(template="table")}
    {tableparams allowtableexpansion="y" shownbitems="y" title="!This is the title
And this is the subtitle"}
    {column label="Book Title" field="book_title"}
    {column label="Author" field="author"}
    {column label="Pages" field="pages"}
    {column label="Year" field="year"}
{OUTPUT}
  {FORMAT(name="book_title")}{display name="tracker_field_bookTitle"}{FORMAT}
  {FORMAT(name="author")}{display name="tracker_field_bookAuthor"}{FORMAT}
  {FORMAT(name="pages")}{display name="tracker_field_bookPages"}{FORMAT}
  {FORMAT(name="year")}{display name="tracker_field_bookYear"}{FORMAT}
{LIST}

Media List Formatting

Tiki13+
This sample presents a list of badges obtained by the current user.

Sample using the default media list formatting
{LIST()}
  {filter relation="" objecttype="user" qualifier="tiki.badge.received.invert"}
  {OUTPUT(template="medialist")}
    {icon field="tracker_field_image"}
    {body field="tracker_field_description"}
  {OUTPUT}
{LIST}

No results for query.

Tiki14+
This sample presents agile gallery of images as a Bootstrap Carousel.

Sample using the default Bootstrap Carousel formatting
{LIST()}
  {filter field="gallery_id" content="1"}
  {OUTPUT(template="carousel")}
    {carousel interval="2000" wrap="true" pause="hover" id="mycarousel"}
    {body field="pic" mode="raw"}
    {caption field="caption"}
  {OUTPUT}
  {FORMAT(name="pic")}{display format="wikiplugin" name="wikiplugin_img" fileId="object_id" styleimage="width:100%"}{FORMAT}
  {FORMAT(name="caption")}
!!! {display name="title" default="Untitled"}
{display name="description" default=""}{FORMAT}
{LIST}

Example

Count Formatting

Tiki15+
This sample shows how to return a simple count of the number of tracker items in tracker 7. For best performance, it is advised to set the max returned results to 1 to prevent having the index to send all the info for all the results (which will slow the request down unnecessarily).

{LIST()}
  {pagination max=1}
  {filter type="trackeritem"}
  {filter field="tracker_id" content="7"}
  {OUTPUT(template="count")}
  {OUTPUT}
{LIST}


121

Report Formatting

Tiki20+
This allows you to have specific output format in a wiki page using CALC wiki plugin to execute a formula on the whole result set returned by the list plugin, thus - do aggregations on the data. Useful for reports on more than one tracker item or the whole search result set.

(also see Calculations Syntax)

Example:

{LIST()}
{filter field="tracker_id" content="45"}
{filter type="trackeritem"}
{OUTPUT(report="y")}
There are {CALC()}(count results){CALC} entries.
The total amounts are {CALC()}
(add (for-each (list results) (formula (if (equals tracker_field_trCurrency (str USD)) tracker_field_trAmount 0))))
{CALC} USD and {CALC()}
(add (for-each (list results) (formula (if (equals tracker_field_trCurrency (str MOP)) tracker_field_trAmount 0))))
{CALC} MOP.
{OUTPUT}
{LIST}


The new subtotal function aggregates data based on a single column (username in our case) and applies an aggregate function to the rest of the columns (you can choose which ones and what functions to apply). The example aggregates time sheet entries based on the username and applies the 'add' function to the time sheet minutes and 'count' function to the invoice number field. At the end, we have the data in this format:
user1|1250|3
user2|140|1
which is suitable for PluginFancyTable. As you can see in the example, we put the results in a fancytable, so a nice-looking report is done. You can add as many filters to the LIST plugin as you want, so time-constrained data is returned.

{LIST()}
{filter field="tracker_id" content="22"}
{filter type="trackeritem"}
{OUTPUT(report="y")}
{FANCYTABLE()}
Username|Duration|Invoice
{CALC()}
(subtotal (list results) (group tracker_field_TimeSheetWorkerUsername) (aggregate tracker_field_TimeSheetMinutesWorked tracker_field_TimeSheetInvoiceFromFreelancer) (formula add count) (separators (str |) (str ~nl~)))
{CALC}
{FANCYTABLE}
{OUTPUT}
{LIST}

Wiki Formatting (Within Plugin)

For each result, the plugin allows to apply a template. See PluginList advanced output control block.

All the LIST Plugin control blocks

doc.tiki.org

Bootstrap AdminGuide UserGuide

Keywords

Keywords serve as "hubs" for navigation within the Tiki documentation. They correspond to development keywords (bug reports and feature requests):

Accessibility (WAI and 508)
Accounting
Articles and Submissions
Backlinks
Banners
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Link Cache
Calendar
Category
Chat
Clean URLs
Comments
Communication Center
Compression (gzip)
Contacts (Address Book)
Contact us
Content Templates
Contribution
Cookie
Copyright
Credit
Custom Home and Group Home Page
Date and Time
Debugger Console
Directory of hyperlinks
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
Draw
Dynamic Content
Dynamic Variable
External Authentication
FAQ
Featured links
File Gallery
Forum
Friendship Network (Community)
Gmap Google maps
Groups
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
Kaltura video management
Karma
Live Support
Login
Logs (system & action)
Look and Feel
Lost edit protection
Mail-in
Map with Mapserver
Menu
Meta Tags
Mobile Tiki and Voice Tiki
Mods
Module
MultiTiki
MyTiki
Newsletter
Notepad
Payment
Performance Speed / Load
Permissions
Platform independence (Linux-Apache, Windows/IIS, Mac, BSD)
Polls
Profiles
Profile Manager
Report
Toolbar
Quiz
Rating
Feeds
Score
Search engine optimization
Search
Search and Replace
Security
Semantic links
Shadowbox
Shadow Layers
Share
Shopping cart
Shoutbox
Slideshow
Smiley
Social Networks
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Stats
Surveys
Tags
Task
Tell a Friend, alert + Social Bookmarking
TikiTests
Theme CSS & Smarty
Trackers
Transitions
TRIM
User Administration including registration and banning
User Files
User Menu
Watch
WebDAV
Webmail
Web Services
Wiki History, page rename, etc
Wiki Plugin extends basic syntax
Wiki Syntax
Wiki structure (book and table of content)
Workspace
WSOD
WYSIWYCA
WYSIWYG
XMLRPC

Tiki Newsletter

Delivered fresh to your email inbox!
Newsletter subscribe icon
Don't miss major announcements and other news!
Contribute to Tiki
Show PHP error messages