Loading...
 
Skip to main content

History: PluginTrackerList

Preview of version: 227

Plugin Tracker List

Use this wiki plugin for Trackers to display a report of the listed items of a Tracker. You can choose which fields you want to display, you can display status of the items, and you have the opportunity to filter the items. Only fields set as public are available through the plugin.

Since Tiki7, there is a more modern (and slightly more complicated) way of displaying tracker listings (and more). Please see PluginLIST and CustomSearch.
Since Tiki19, there is a tool to automatically convert a TrackerList plugin into a List plugin. See PluginTrackerList To PluginList Converter.


Parameters


-

List, filter and sort the items in a tracker
Introduced in Tiki 1. Required parameters are in bold.
Go to the source code
Preferences required: feature_trackers, wikiplugin_trackerlist

Parameters Accepted Values Description Default Since
(body of plugin) Notice
trackerId digits Numeric value representing the tracker ID 1
tstotalformat Format for table totals (click here for patterns). Example: #,###.
ldelim Smarty left delimiter for Latex generation. Example:@{ { 2.0
rdelim Smarty right delimiter for Latex generation Example:}@ } 2.0
tpl Use content of the specified tpl file as template to display the item. Use {$f_fieldId} to display a field with ID fieldId. 2.0
urlafterdelete url Url to redirect to after delete 11.0
allowStickyHeaders (blank)
n
y
Sticky Headers for the table when scrolling top Default value: No n 26
force_separate_compile (blank)
y
n
Compile each item separately instead of compiling the entire template. y 11.0
displaysheet (blank)
y
n
Display tracker as a spreadsheet (not used by default) n 6.0
list_mode (blank)
y
n
csv
Set output format. Yes (y) displays tracker list view with truncated values (default); No (n) displays in tracker item view; Comma Separated Values (csv) outputs without any HTML formatting. y 3.0
popup digits
separator: :
Colon-separated list of fields which will display in a tooltip on mouse over. Example: 6:7. Setting this parameter implies y value for sort param. 2.0
sort (blank)
y
n
Display columns in the order listed in the fields parameter instead of by field ID (field ID order is used by default n 2.0
sortchoice text
separator: :
Add a dropdown of sorting choices. Separate each choice with a :. For each choice, use the format value|label. See sort_mode for value choices. Example with two sorting choices: sortchoice="created_desc|Newest first:lastModif_desc|Last modified first" 5.0
stickypopup (blank)
y
n
Choose whether the popup tooltip will stay displayed on mouse out (does not stay open by default) 2.0
export (blank)
y
n
Show an export button (not shown by default) n 3.0
force_compile (blank)
y
n
Force Smarty to recompile the templates for each tracker item when using a wiki page as a template. Default=n (best performance) n 6.0
editableall (blank)
y
n
Allow all displayed fields to be editable y 11.0
sort_mode Sort rows in ascending (_asc) or descending (_desc) order based on field ID, date created or date last modified 1
tplwiki pagename Use content of the wiki page as template to display the item but with as little parsing on the content as with a tpl on disk. The page should have the permission tiki_p_use_as_template set, and should only be editable by trusted users such as other site admins 6.5 & 7.1
wiki pagename Use content of the wiki page as template to display the item. The page should have the permission tiki_p_use_as_template set, and should only be editable by trusted users such as other site admins 2.0
compute Sum or average all the values of a field and displays it at the bottom of the table. fieldId/sum:fieldId/avg 3.0
fields digits
separator: :
Colon-separated list of field IDs for the fields to be displayed. Example: 2:4:5. The field order specified here determines the column order if the sort parameter is set to y. 1
editable digits
separator: :
Colon-separated list of fields for which inline editing will be enabled. 11.0

Additional information when using tablesorter and the server parameter (Server Side Processing) is set to y:
  • Filtering and sorting on some field types (e.g., items list), may behave unexpectedly
  • For best results the date filter should only be applied to date field types
  • To filter the category field type, the exact category name or id needs to be entered


 Note
These parameters allow the results to be pre-filtered before the user sees them. To allow the user to filter, sort or paginate results, see the parameters under the tablesorter tab.
List, filter and sort the items in a tracker

Go to the source code

Parameters Accepted Values Description Default Since
view_user Will display the items of the specified user 2.0
max int Maximum number of items to display or -1 for all items. Defaults to max records preference, if set. Pagination will not show if all items are shown by setting to -1. 1
offset int Offset of first item. Default is no offset. 0 6.0
periodQuantity int Numeric value to display only last tracker items created within a user defined time-frame. Used in conjunction with the next parameter "Period unit", this parameter indicates how many of those units are to be considered to define the time frame. Use in conjunction with max=-"1" to list all items (by default max is set to 10). 6.5, 7.x & 8.0
forceoffset (blank)
y
n
Fix offset to that specified. This will disallow pagination. n 8.0
periodType (blank)
c
m
Time period after creation or after modification 6.7, 7.x, 8.4 & 9.0
periodUnit (blank)
hour
day
week
month
Time unit used with "Period quantity" 6.5, 7.x & 8.0
status (blank)
o
p
c
op
oc
pc
opc
Only show items matching certain status filters (only items with open status shown by default) o 1
exactvalue
separator: :
Exact value (or multiple values) that correspond to filterfield.
Special search values to filter by:
categories(x) - tracker item is in category with ID x or one its descendants
notcategories(x) - tracker item is not in category with ID x or one of its descendants
preference(name) - match against the value of a Tiki preference
notpreference(name) - match if value does not equal a Tiki preference value
not(value) - match if the field does not equal "value"
not() - match for non empty values (opposite with exactvalue="")
or(value1,value2) - match if the field equals "value1" or "value2" (can list more than 2 alternative values)
field(x, itemid) - match field with ID x in item with ID itemid. field(x) can be used if the itemId URL parameter is set
notfield(x, itemid) - match if not equal to field with ID x in item with ID itemid field(x) can be used if the itemId URL parameter is set
The following comparisons can also be applied to date fields by using date phrases that PHP recognizes (see https://doc.tiki.org/Date-and-Time-Features ):
less(value) - match if less than "value"
greater(value) - match if greater than "value"
lessequal(value) - match if less than or equal to "value"
greaterequal(value) - match if greater than or equal to "value"
1
filtervalue
separator: :
Filter value (or multiple values) that correspond to filterfield. For better performance, use exactvalue instead.
Special search values to match:
*value - text that ends in "value"
value* - text that begins with "value"
#user - the current user's login name
#group_default - the current user's default group.
To filter by empty/non-empty values, use parameter exactvalue instead
1
ignoreRequestItemId (blank)
y
n
Ignore the itemId url parameter when filtering list (not ignored by default) n 5.0
itemId digits
separator: :
Colon-separated list of item IDs to restrict the listing to 2.0, multiple since 3.0
view (blank)
page
user
group
ip
Display only the items of the following:
user - the current user
group - the current user's groups
page - the current page name
ip - the current IP address
2.0
goIfOne (blank)
y
n
Display the item rather than list if only one item is found 1
filterfield digits
separator: :
Colon-separated list of fields to allow filtering on. 1


List, filter and sort the items in a tracker

Go to the source code

Parameters Accepted Values Description Default Since
checkbox Adds a checkbox on each line to perform an action. Required elements are separated by /. Those elements are:
FieldId - the value of this field will be posted to the action
PostName - the name of the post
Title - the title of the submit button
Submit - the name of the submit button
ActionUrl - the file that will be called upon submit
Tpl - optional template inserted before the submit button and returned
SelectType - Leave empty for multiple select, or use dropdown or radio.
Embed - Set to %0y%1 if the trackerlist table is embedded inside an existing form. ActionUrl is ignored in this case.
Checked - comma-separated list of pre-checked items
Format: checkbox="FieldId/PostName/Title/Submit/ActionUrl/Tpl/SelectType/Embed/Checked"
Example: checkbox="6/to/Email to selected/submit/messu-compose.php//dropdown//1,2,3"
1
moreurl url More link pointing to specified URL instead of default tracker item link tiki-view_tracker.php 2.0
showlastmodif (blank)
y
n
Last modification date display is based on tracker settings unless overridden here 2.0
showlastmodifby (blank)
y
n
Last modified by user display is based on tracker settings unless overridden here 14.0
more (blank)
y
n
Show a 'more' button that links to the tracker item (not shown by default) n 2.0
showcloseitem (blank)
y
n
Show a close item option (not shown by default) n 8.0
showcomments (blank)
y
n
Show comments count or last comment date and user depending on tracker preferences y 16.0
showcreated (blank)
y
n
Creation date display is based on tracker settings unless overridden here 2.0
showdelete (blank)
y
n
Show a delete icon for each item (not shown by default) n 4.0
showdesc (blank)
y
n
Show the tracker's description (not shown by default) n 1
showrss (blank)
y
n
Show an RSS feed button (not shown by default) n 5.0
showfieldname (blank)
y
n
Use the field names as column titles (used by default) y 1
showinitials (blank)
y
n
Show an alphabetical index by first letter to assist in navigation (not shown by default) n 1
shownbitems (blank)
y
n
Show the number of items found (not shown by default) n 2.0
showitemrank (blank)
y
n
Show item ranks (not shown by default) n 4.0
showlinks (blank)
y
n
r
Show links to each tracker item (not shown by default). At least one field needs to be set as Public in order for this to work. n 1
showopenitem (blank)
y
n
Show an open item option (not shown by default) n 8.0
showpagination (blank)
y
n
Determines whether pagination will be shown (shown by default) y 4.0
showpenditem (blank)
y
n
Show a pending item option (not shown by default) n 8.0
showmap (blank)
y
n
Show Map of results (not shown by default) 12.0
showstatus (blank)
y
n
Show the status of the items (not shown by default) n 1
showtitle (blank)
y
n
Display the title of the tracker (not shown by default) n 1
showwatch (blank)
y
n
Show a watch button (not shown by default) 5.0
allowtableexpansion (blank)
y
n
Show 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 (not by default). n 18.0
silent (blank)
y
n
Show nothing if no items found (the table header and a 'No records found' message is shown by default). 4.0
url url The link that will be on each main field when showlinks="y". Special values:
url="mypage?itemId" - will link to the item based on its item ID
url="mypage?tr_offset" - will link to the item based on its offset value
url="sefurl" - will link to the item using itemX (where X is the item ID) for when SEFURL is being used
vi_tpl - use to show the item without admin buttons and with a back button when using a template (Display > Section Format must be set to "Configured" in the tracker properties). Example: url="tiki-view_tracker_item.php?vi_tpl=wiki:PageName&itemId"
ei_tpl - similar to vi_tpl except that admin buttons are shown for users with proper permissions when "Restrict non admins to wiki page access only" is set in the tracker properties.
2.0, 3.0 for itemId, 11.0 for tr_offset, 14.0 for sefurl and vi_tpl


List, filter and sort the items in a tracker

Go to the source code

Parameters Accepted Values Description Default Since
calendartitle text Enter a title to display a calendar title (not set by default) 6.0
calendarbeginmonth (blank)
y
n
Set whether calendar will begin at the beginning of the month (does by default). y 6.0
calendardelta (blank)
+month
-month
+bimester
-bimester
Set the calendar delta that will be shown (not set by default) 6.0
calendarpopup (blank)
y
n
Calendar items will popup, overrides the stickypopup parameter if turned off (default is to pop up). y 6.0
calendarviewmode (blank)
month
bimester
trimester
quarter
semester
year
Calendar view type time span (default is month) month 6.0
calendarviewnavbar (blank)
y
n
partial
Show calendar navigation bar (shown by default). y 6.0
calendarstickypopup (blank)
y
n
Calendar item popups will stay open if set to y (Yes). Not sticky by default n 6.0
calendarfielddate digits
separator: :
Used to display items in a calendar view. One fieldId if one date, or 2 fieldIds separated with : for start:end 6.0



These parameters allow the user to filter, sort or paginate the results of the trackerlist query. To pre-filter or sort results before the user sees them, use the parameters in the general and filtering tabs.
In order to use tablesorter,

  1. Javascript must be enabled
    • Enabled by default at Admin > Features > Programmer (tab)
  2. jQuery Sortable Tables must be activated
    • Enable at Admin > Features > Interface (tab)
  3. For the server parameter to work for a plugin, ajax must be enabled
    • Enable at Admin > Features > Interface (tab)
List, filter and sort the items in a tracker

Go to the source code

Parameters Accepted Values Description Default Since
sortable any string except for HTML and PHP tags Serves as the overall switch for turning jQuery Tablesorter on (also for filtering) as well as overall sort settings. Enter y to allow sorting and n to disallow (n is the default). Enter type:save to allow sorts to be saved between page refreshes. Enter type:reset;text:***** to allow sorting and show an unsort button with custom text. Enter type:savereset;text:buttontext to allow the same for saved sorts. n 12.0
server any string except for HTML and PHP tags Enter y to have the server do the sorting and filtering through Ajax and n to have the browser do it (n is the default). Set to y (and also set the Paginate parameter (tspaginate)) if you do not want all rows fetched at once, but rather fetch rows as you paginate, filter or sort. n 12.0
tsfilters any string except for HTML and PHP tags Enter y for a blank text filter on all columns, or n for no filters. Or set custom column filters separated by | for each column for the following filter choices and parameters:
Text - type:text;placeholder:xxxx
(For PluginTrackerlist this will be an exact search, for other plugins partial values will work.)
From Tiki 18, you can add initial:t option to allow prefix search for text filter. E.g. type:text;initial:t
Dropdown - type:dropdown;placeholder:****;empty:****;option:****;option:****;option:****
Options generated automatically if not set and the server parameter is not y.
Use value=Display label to have the option value be different than the displayed label in the dropdown.
Use empty:Display label to include an option with the specified label that will filter only empty rows. Only used if other options are not specified manually.
Date range - type:date;format:yy-mm-dd;from:2013-06-30;to:2020-12-31
(from and to values set defaults for these fields when user clicks on the input field)Beware that items with empty date values will not be shown when default date range filters are applied.
Numeric range - type:range;from:0;to:50
No filter - type:nofilter
For example: tsfilters="type:dropdown;placeholder:Type to filter..." would result in a dropdown filter on the first column with all unique values in that column in the dropdown list.
12.0
tscolselect any string except for HTML and PHP tags Add a button for hiding and re-showing columns. Also sets priority for dropping columns when browser is too narrow. Set each column to a number between 1 and 6 (1 is highest priority and last to be dropped) or to critical to never hide or drop. An example with 4 columns:tscolselect="critical|4|5|6" 14.0
tsfilteroptions any string except for HTML and PHP tags The following options are available: reset (adds button to take off filters), and hide (Filters are revealed upon mouseover. Hide doesn't work when date and range filters are used.). To use both, set tsfilteroptions="type:reset;text:button text;style:hide" 12.0
tsoutput any string except for HTML and PHP tags Enter y to set default values based on the site setting. Set custom values as in the following example: delivery:d;saveFileName:exported_teblesorter.csv 24.5
tspaginate any string except for HTML and PHP tags Enter y to set default values based on the site setting for maximum records in listings (on the pagination table of the Look & Feel admin panel). Set to n (and server cannot be set to y) for no pagination. Set custom values as in the following example: max:40;expand:60;expand:100;expand:140 12.0
sortList any string except for HTML and PHP tags Bracketed numbers for column number (first column = 0) and sort direction (0 = ascending, 1 = descending, n = no sort, y = allow sorting but no pre-sort), for example: [0,y],[1,0],[2,n]. If the first pre-sorted or no filter column is not the first column, then you should use the y parameter (as in [0,y]) to assign all previous columns. 12.0
tsortcolumns any string except for HTML and PHP tags Set type and group settings for each column, using | to separate columns. To show group headings upon page load, the Pre-sorted Columns parameter (0sortList) will need to be set for a column with a group setting. Group will not work in plugins where the Server Side Processing parameter (server) is set to y.
Set type to one of the following: text, digit, currency, percent, usLongDate, shortDate, isoDate, dateFormat-ddmmyyyy, ipAddress, url, time, nosort
Also handle strings in numeric columns with: string-min, string-maxHandle empty cells with: empty-top, empty-bottom, empty-zero.
group creates automatic row headings upon sort with the heading text determined by the setting as follows: letter (first letter), word (first word), number, date, date-year, date-month, date-day, date-week, date-time.letter and word can be extended, e.g., word-2 shows the first 2 words. number-10 will group rows in blocks of ten. Group will not work in plugins where the Server Side Processing parameter (server) is set to y.
12.0
tstotaloptions any string except for HTML and PHP tags Pipe-separated options for totals for each column which are set in the tstotals parameter:
format - overrides the default number format set in tstotalformat
ignore - column will be excluded from total calculations set in the tstotals parameter. Remember to include any columns that will be added for row totals set in the tstotals parameter.
Example:ignore|ignore|#,###.
15.0
tstotals any string except for HTML and PHP tags Generate table, column or row totals and set labels, using either y or the following syntax for each total: type:value;formula:value;filter:value;label:value.
Setting to (y) will add one column total row set as follows: type:col;formula:sum;filter:visible;label:Totals.
Separate multiple total row or column settings with a pipe (|). Set type only to generate sums of visible values. In all cases, cells in columns set to be ignored in the tstotaloptions parameter will not be included in calculations.
Instructions for each total option follows:
type - Choices are col, for a row of columns totals, row, for a column of row totals, and all to include amounts from all cells in the table body in a row total.
formula - set what the calculation is. Choices are: sum, count, max, min, mean, median, mode, range, varp, vars, stdevp, stdevs. Click here for a description of these options.
filter - Determines the rows that will be included in the calculations (so no impact if type:row). Also, when server="y", only visible cells are included regardless of this setting. Choices are visible (rows visible on the page), unfiltered (all rows not filtered out, even if not visible because of pagination), all (all rows, even if filtered or hidden), and hidden (rows filtered out and rows hidden due to pagination).
label - set the label for the total, which will appear in the header for row totals and in the first column for column totals.
15.0



More information on parameters

  • when filterfield is a dropdown box, exactvalue must be the text of the item in the drop down list without quotation marks
  • when filterfield is a category, exactvalue must be the numeric id (without quotation marks) of the category item to filter the list
  • when filterfield is a checkbox, exactvalue is y or n


Please note that there might be a bug in Tiki 9.x and later versions, which causes filterfield to work only for Admins when the fields parameter is missing. To make it work for other Groups, you need to set fields parameter and explicitly name all fields you want to display. For example:

Copy to clipboard
{trackerlist trackerId="2" list_mode="csv" fields="17:42:43:44:47" filterfield="44" exactvalue="y" tplwiki="Template page for a Slide"}


After tw>=2.0 filterField can specify a list of fieldIds. In this case filtervalue and exactvalue must be synchronised to filter the value of each field

  • Example: filterfield=1:2, filtervalue=this:that

will filter the items with the field 1 'like' this and field 2 like 'that'

  • Example: filterfield=1:2, exactvalue=this:that

will filter items with the field 1 equals to 'this' and field 2 equals to 'that'

  • Example: filterfield=1:2, filtervalue=:this, exactvalue=that

will filter items with field 1 equals to 'that' and field 2 likes 'this'

  • Example: FieldId 1 is the itemId fields (auto-increment itemId) filterfield=1, notfield(1) and with an url containing itemId will give all the items except the onde defined in the url


If you are having trouble getting your filters to apply, try using syntax like filterfield="2:1" and exactvalue="value for 2:value for 1" , where the quotation marks enclose all of the values.

Filtering on item list fields
Note that for filtering on item list fields through filterfield, it is important to ensure that fields contain the filterfield id as well. This is because of the special way item list fields are filtered due to its special nature.

Also, if there are multiple items in the value of filterfield, the value you should attempt to match against is item1,item2,item3 if using exactvalue. If you are using filtervalue which does partial matching, from Tiki 6.2, you can match against ",item1,item2,item3,". This is to avoid ambiguity in certain cases. For example, if you are trying to match for a number like "32" in a sequence of numbers like "132,32,321" it can be ambiguous since you might accidently get those that match "21,132". To solve this, from Tiki 6.2, you can set the filtervalue to ",32," to make sure you match only those sequences that include 32 and not things like 132.


(or how to send a message to multiple users shown through plugintrackerlist)
Its params are: fieldId/postName/Title/Submit/ActionUrl/tpl/(empty)|radio|dropdown

  • fieldId is the field Id whose value will be posted to the action
  • postName is the name of the post
  • Title is the title of the button
  • Submit is the name of the submit button
  • ActionUrl is the script that will be called on the submit
  • tpl is an optional template that be inserted before the submit button that will also be returned
  • radio or dropdown. If this param is left blank/empty, multiple checkbox will be used instead.


Example:
checkbox="6/to/Email to the checked/submit/messu-compose.php//"

in this example the fieldId 6 is the user name as messu-compose.php accepts to as param, and multiple checkboxes will be shown on the left to select one or more user to send a message to.


How to go from a TRACKERLIST page to a page with a TRACKER for a specific item
You want to be able from a TRACKERLIST page to select an item and to go on another page where you can modify your item. We will call this page UpdateItem. We will suppose that the field 1 is a main field (it display a link to the item.
To do so use the parameter url in TRACKERLIST

Copy to clipboard
{trackerlist ....fields="1" showlinks="y" url="tiki-index.php?page=UpdateItem&itemId="}

The page UpdateItem needs just to use a regular TRACKER plugin. If itemId is present in the URL, it will be automatically prefilled with the value of the item.

'Pretty Trackers' (param tpl or wiki)
It is possible to control how an item is displayed in a page by using a Smarty template or a wiki page containing smarty code. In the case of a wiki page containing smarty code, keep in mind that this page should be kept editable only by trusted users, such as other site admins.

For instance in a page (named 'list of items in tracker 5') for example, you have

Copy to clipboard
{trackerlist trackerId="5" fields="30:31" showcreated="y" wiki="tpl for each item in tracker 5"}

where fieldId=30 and fieldId=31 are 2 fields of the trackerId 5
In the page named 'tpl for each item in tracker 5', you will have

Copy to clipboard
http://doc.tiki.org/tiki-editpage.php?page=PluginTrackerList&hdr=5 {$f_30} : {$f_31}{tr} was created in {/tr}__{$f_created|tiki_short_date}__

PS: the wiki page 'tpl for each item in tracker 5' needs the perm tiki_p_use_as_template for Anonymous (or Registered, depending on your case) to be displayed, and tiki_p_edit for Admins, in order to prevent any users to add any smarty code in it, which might be unsafe.
When displayed, the page 'list of items in tracker 5' will look like this

Copy to clipboard
324: foobar was created on __Thu 23/10/08__ 311: toto was created in __Wed 23/10/07__

There is no more table (if you did not recreate them in 'tpl for each item in tracker 5' for course). Of course the name of the 'template' page is whatever you want - you need only to give the good reference in the param 'wiki'
PS: $f_created and $f_lastmodif display the integer value of the associated date. $f_status will output o or p or c . $f_status_input will output the status select box.
Tip: you can use {$f_created|date_format:"%I:%M %p"} or {$f_created|tiki_short_date}

You can use also a template file in the file system

Copy to clipboard
{trackerlist trackerId="5" fields="30:31" showcreated="y" tpl="B"}

and create a templates/B.tpl. In this case no permissions are required.

How to have a pagination between the items accessed by TRACKERLIST (tiki>=6)

No Pretty Tracker

  • If you do not use pretty tracker for instance a TRACKERLIST with no url parameter and parameter showlinks=y , each time you click on an item link you will go to tiki-view_traker_item.php and you will see pagination between item.
  • If you are using TRACKERLIST with the url parameter equal to page?itemId for instance and if you want that each item displays a pagination to the next/previous item you need to have showpagination=y
  • This pagination is very convenient when you are using TRACKERFILTER or use some specific filtering of TRACKERLIST as only the filtered items are in the pagination


With Pretty Tracker (starting with Tiki11)

  • If using custom templates for display (pretty trackers), use tr_offset instead of itemId . Here is an example of how this can be used:
  1. Use PluginTrackerList to list items from a tracker.
    1. Set the url parameter to url="ItemPageName?tr_offset . This will cause title fields in the list to be links to this page
  2. ItemPageName will consist of another instance of PluginTrackerList.
    1. This time the fields parameter should include the field IDs that should appear on the individual item page.
    2. showpagination should be set to y so that pagination with be shown
    3. The wiki or tpl parameter will be set to the custom template page that has been created to display single tacker items from this tracker. Since the tr_offset parameter was set when calling this page, only one item will be shown.


URL Params

  • tr_user: if &tr_user=username is set in the URL request, the plugin loads the specified user item(s) (trackerId must be specified)


Nested plugins in 'pretty' templates
Since Tiki6.0, it is possible to 'nest' plugins - meaning another plugin can be invoked in the template file where smarty code is used to assign parameters which are defined by the first trackerlist.

  • WARNING: will only work if the first (or any level except the last) trackerlist delivers one item


For example:
If a 'first level' plugin such as:

Copy to clipboard
{trackerlist trackerId="2" view="page" max="1" fields="43:50" filterfield="43" exactvalue="Test Reference" wiki="insert_location tpl" status="opc" ignoreRequestItemId="y"}


is used in a wiki page, and the wiki template "insert_location tpl" has within it a second level plugin such as:

Copy to clipboard
{trackerlist trackerId="30" fields="75:907" list_mode="n" filterfield="75" exactvalue="{$f_50}" wiki="stdlocmap tpl"}


where the wiki template "stdlocmap tpl" is as follows:

Copy to clipboard
{$f_75} {$f_907}


Then the result is that the original page will display the field values f_75 and f_907 from the second tracker (id# 30) where the item is defined by a match between a designated value in the tracker and the same value in the second tracker.


This allows you to display global information about a numeric field like the sum of all the values or the average.

Tiki6: The items shown by the tracker list (e.g., filtered with the parameters filtervalue or exactvalue ) are the only ones used for the computation (average or sum), and not all the items in the same tracker.

Copy to clipboard
{trackerlist trackerId="5" fields="12:15:142:466" compute="142:466/avg"}

will give something like
Image
If you want to use sum and average on the same field use compute=146/sum:146/avg

Decimals in values are indicated with the dot (".") and not with the comma (",").


If your tracker has a field named 'page' and if the url contains the param 'page', TRACKERLIST will automatically filter the items that have the value of the page url param equal to the page item filed value.

With the parameter calendarfielddate , you can display the list of the items in a calendar view. See Module calendar_new. The plugin collects all the items of the period and displays in a popup the items. The display is either the pretty tracker template specified by the param wiki or the value of main field.The calendarfieldate can contain either a single date field or 2 date fields.
Example:
trackerlistcalendar.png
Has been produced by a user module containing the code:

Copy to clipboard
__Formations à venir__ {trackerlist trackerId="11" ignoreRequestItemId="y" fields="56:58" url="formation&itemId" showlinks="y" filterfield="56" exactvalue="greaterequal(now)" calendarfielddate="56" calendarviewmode="month" calendarstickypopup="y" wiki="trackerCalendrierFormation" calendarviewnavbar="n" wiki="trackerFormationCalendrier" calendarviewnavbar="partial"} {trackerlist trackerId="11" ignoreRequestItemId="y" fields="56:58" url="formation&itemId" showlinks="y" filterfield="56" exactvalue="greaterequal(now)" calendarfielddate="56" calendarviewmode="month" calendarstickypopup="y" wiki="trackerCalendrierFormation" calendarviewnavbar="n" calendardelta="month" wiki="trackerFormationCalendrier"}

Examples

Sorting, filtering and pagination

Beginning with Tiki12, tablesorter parameters have been added (see the tablesorter tab in the parameter list above) to allow the user to sort, filter and paginate through the trackerlist results. Below is an example.

This code:

Copy to clipboard
{trackerlist trackerId="8" fields="111:112:113" showlinks="y" showpagination="y" more="n" server="n" sortable="type:reset" sortList="[0,1],[2,0]" tspaginate="max:10" tsfilters="type:text;placeholder:Type a digit...|type:text;placeholder:Type to filter...|type:dropdown|type:date" tsortcolumns="type:digit;group:number-3|type:text|type:text;group:word-3|type:isoDate;group:date-month"}


Would show the following on this site:


Some notes:

  • Sort the columns to see automatic group headers for all but the second column
  • Only one column can be sorted with the sortList parameter if the server parameter is set to y , otherwise multiple columns may be set
  • The tsortcolumns parameter determines the group headings and also helps the program to know what type of data is being sorted so that sorting is more accurate
  • The drop down in the third column is automatically generated. Automatic dropdowns can only be generated in these cases:
    • The server parameter is not set to y , or
    • The field is a tracker type "dropdown" where the dropdown options have been specified in the tracker field definition
  • As you scroll down the page, the table header rows will always be visible as long as the table is visible
  • the date filter from and to dates are customizable as is the date format
  • Setting server to y would allow for only the visible rows to be fetched from the database
  • To sort or filter a status field, you must set server="y" (and thus use ajax)

How to filter a tracker function of a field in a user tracker.

For instance, you have a user tracker with a field Town, you have another tracker listing all the bakeries. This tracker has also a field Town. You want to display all the bakeries in the town of your user. For this you can use

Copy to clipboard
{trackerlist trackerId="5" fields="21:23:24" filterfield="20" exactvalue="field(38,user,7)"}

where 5 is the trackerId of the bakery, 20 is the fieldId of Town in the tracker bakery, 38 is the fieldId of the Town in the user tracker 7.

You can use as many filters you want. For instance, you can filter on the Town and the nationality with the type of bakery...

With the same principle, you can display all the items of the user tracker that have the same Town than the user. or the same Town and same age that the user.

How to make columns larger via CSS

While hardcoding values is possible, this is a "last resort" solution. It will broke the mobile compatibility and a bad practice to use the Custom CSS for such adjustment. It is better to use the plugin list and create exactly what you want.

Add
Copy to clipboard
.field2 { width: 500px;}
in Custom CSS where 2 is the tracker field id and 500 is the number of pixels for the column

See also:

History

Advanced
Information Version
Bernard Sfez / Tiki Specialist 228
Bernard Sfez / Tiki Specialist Added information about hardcoding value in Custom CSS as someone pointed to me that "it's in your Doc!" 227
Bernard Sfez / Tiki Specialist 226
Jean-Marc Libs 225
drsassafras Mass search and replace 224
drsassafras Mass search and replace 223
Roberto Kirschbaum Reference to TrackerListToListConverter 222
Yves Kipondo 221
Xavier de Pedro 220
luciash d' being 🧙 typos 219
luciash d' being 🧙 218
lindon Edit restored by rescue script 2017-04-24T18:09:12+00:00 217
lindon 216
pianoliv adding link to related ((pluginLIST)) 215
lindon 214
lindon 213
lindon 212
lindon 211
Torsten Fabricius added vi_tpl subparameter for param url 210
Torsten Fabricius 209
Torsten Fabricius editableall test done 208
Torsten Fabricius editableall test 207
Xavier de Pedro re-add the info about using param view=ip (I did read this in this page years ago, and I cofirm that this param still works as expected in current 9.9svn, at least) 206
lindon 205
lindon 204
lindon 203
lindon 202
lindon 201
lindon 200
lindon Tabs Plugin modified by editor. 199
lindon Tabs Plugin modified by editor. 198
lindon Tabs Plugin modified by editor. 197
lindon 196
lindon 195
lindon 194
lindon Tracker List Plugin modified by editor. 193
lindon 192
lindon 191
lindon 190
lindon 189
lindon 188
lindon 187
lindon 186
lindon 185
lindon 184
lindon 183
lindon Tracker List Plugin modified by editor. 182
lindon 181
lindon 180
lindon 179