Category: Wiki Plugin (extends basic syntax)

Tracker plugin show logged user info and not actual tracker data for user preference fields.

Instead of this:
{img src=images/code.png}%%% {CODE()}
*[tiki-view_tracker_item.php?itemId=909|Integrating fotonotes or wikigraphe or DOM Image annotation to the Image gallery]
{CODE}

I should be able to indicate something like:
{img src=images/code.png}%%% {CODE()}
*{bug909}
{CODE}

and have the nice link generated. And if the title of the bug changes, I am OK. Having some more info about the bug in a mouse over would be a nice bonus!

Having a drop down menu or bug picker would be sweet too!

Maybe even some backlinks detection!

You can see an nice example here that even has a bug icon
http://winscp.net/eng/docs/history

I set the tracker plugin with transaction step.
So I split the initial plugin tracker into 5 plugin trackers setting the following parameters for each one: transactionName, transactionStep and transactionFinalStep.
Something that looked like:

{CODE()}{TRACKER(trackerId="4" fields="1:2:3" transactionName="new" transactionStep="0" transactionFinalStep="n")}{TRACKER}{CODE}

{CODE()}{TRACKER(trackerId="4" fields="4:5:6" transactionName="new" transactionStep="1" transactionFinalStep="n")}{TRACKER}{CODE}

…/… till the last step a bit different.

{CODE()}{TRACKER(trackerId="4" fields="10:11:12" action="Save" transactionName="new" transactionStep="4" transactionFinalStep="y")}Thanks{TRACKER}{CODE}

The page show an error : You need to define both transaction name and transaction step, or none of the two.

It has been confirmed that it is not working

When using the Tracker Plugin in a form to input data the Text and Text Area Field Types are not displaying the acutal input box, only the field description is showing. I have temporarily changed the field types to other types (checkbox, dropdown, etc) and then the actual input box does appear.

I have tested the same form on several different TikiWiki 2.0 sites and I have the same problem on each of the different sites.

Since Tiki 17 (default setting + trackers) the tracker plugins (that have a parameters for fields) it is not possible to set the fields order using the GUI.

The selector fields show then so I can select the fields, but I can’t order them.
It seems the order is set alphabetically…

https://ibb.co/fCBK9a

User should be able to select an order of the fields in the GUI.

When a tracker field type is email, a new option:

sendEmail=y|n|oy|on


This will permit that people that fill in a form get a copy of what they are filling out, which is often the case in public forms.


If this is set to (y)es, an email is sent to this email
If this is set to (n)o, no email is sent to this email
If set to (oy)ptional, the checkbox is check by default
If set to (on)ptional, the checkbox is not check by default

A checkbox is added at the bottom of the form like here:
http://www.comsol.com/support/form.php

2- A distinct email notification tracker would be needed (in addition to templates/mail/tracker_changed_notification.tpl) because we may not always want to disclose the same information to people that fill the form cv admins watching the forms.

3- The "from" email of the notification of this tracker should be the email which is filled in (as an option). So when I am notified about this tracker, I can just click "reply".

The user tracker is very useful:
tiki-view_tracker_item.php?view=+user

However, sometimes, I may want to manage this info in many different wiki pages. For example, I would like to put these three user forms on different wiki pages:

{CODE()}
{TRACKER(trackerId=>9, fields=>1:2:3, usertracker=>y)}{TRACKER}
{CODE}

{CODE()}
{TRACKER(trackerId=>9, fields=>1:4:5, usertracker=>y)}{TRACKER}
{CODE}

{CODE()}
{TRACKER(trackerId=>9, fields=>1:6:7, usertracker=>y)}{TRACKER}
{CODE}

trackerId #9 is a usertracker and field 1 is the login (so we can associate to appropriate tracker)


I would have more freedom to add instructions, comments, etc

Combined with [tiki-view_tracker_item.php?itemId=122|WikiPluginTracker : Confirmation message to any URL], I could create multi-page user trackers.

If the info has already been filled in, the tracker plugin will come-up pre-filled, like tiki-view_tracker_item.php?view=+user does.

We could also have the same concept for the group tracker:
tiki-view_tracker_item.php?view=+group

And why not extend to any tracker?

We often need a way to do conditional things in tracker forms, like show or hide fields depending on the user's input, or require validation on some fields depending on the state of others.

So this is to start a discussion about how this should be implemented, should it be a new field type? Or a function of the tracker plugin (which needs significant tidying up) or what?

So they should look something like:

* Category field
** If Category contains "bug" then
*** Show Workaround and Solution fields
*** Make Importance and Easy To Solve required

I upgraded a Tiki18 to Tiki21 to find out that textArea multilingual is not filtered in the plugin List.

All languages are displayed in a customSearch instead of displaying the only language that correspond to the actual language. (I suspect it will be the same in a List plugin).

Here the tracker edit view showing different languages for different fields (title, abstract, ...)
{img fileId="1418" thumb="box"}

Here the tracker view with English language selected (content is displayed for english only that’s correct)
{img fileId="1419" thumb="box"}

Here the customSearch view with English language selected but all languages are displayed for the field Abstract (note that title, a text field, is working fine)
{img fileId="1417" thumb="box"}

Each tracker can have 1 title field. When an item of that tracker is listed, the value of that field can link to tiki-view_tracker_item.php. When listing with the TRACKERLIST plugin, the showlinks parameter controls this behavior.

As can be seen in Tracker_Field_Abstract::renderOutput(), this works by surrounding the return value of renderInnerOutput() with opening and closing HTML a element tags.

While this works for simple field types, this is highly unreliable when rendering a textarea field which is wiki-parsed. If the parse generates a link, the result is invalid HTML.

For example, if tracker 1 contains a single Textarea field, and a single item with value "foo\n!!! title
", calling the plugin with "~np~{trackerlist trackerId="1" showlinks="y"}~/np~" will cause the field to show as a link only on the first line ("foo"), at least in Google Chrome, since a header inside a link is invalid. I am not sure why, but if listing the items from tiki-view_tracker.php?trackerId=1 instead, the link only stops between the second and third lines (i.e. the title itself links).

This issue has probably been there from the time TRACKERLIST was written (r3627). If not, it must have been in r33456 (see renderValue() in https://sourceforge.net/p/tikiwiki/code/33456/tree/trunk/lib/trackers/trackerlib.php ).

Tracker filter is amazingly cool.

If there is a long list of tracker items, one should be able to search and filter all items based on a text string in any column.


[http://dev.tikiwiki.org/tiki-view_tracker.php?trackerId=5&status=o&sort_mode=f_41_desc&filtervalue%5B26%5D=webmail&filtervalue%5B56%5D=Accepted&filtervalue%5B48%5D=&filtervalue%5B27%5D=&filtervalue%5B28%5D=&filtervalue%5B54%5D=&filtervalue%5B55%5D=&filterfield=26&filter=filter|such things exist!] but are not available in Trackerlist plugin.

Here:
[http://dev.tikiwiki.org/Dynamic Filter]

I would like to add a text field for the description of the bug report.

And have multiple requests like this:
https://sourceforge.net/tracker/?atid=506846&group_id=64258&func=browse

Records are not found when using the trackerfilter plugin where the filter field is an ItemLink field where the contents are 'created' from multiple fields in the source tracker.

A 12.x 'show' has been set up to demo this bug - but it is also a problem in 13.x as well

---

Added quote below ({sign user="xavi" datetime="2014-04-30T09:30:43+00:00"}) as extra info was provided in the devel list:
{QUOTE()}
(...) definitely a regression as I have a production site where it used to work. I can't be sure when it stopped working but the site was built with 10.x so it was OK then and the site is now on a 11.x daily build from 4Sep'13 and it doesn't work anymore - only realised it when I used the site data to test the latest 12.x
{QUOTE}

{syntax type="tiki" editor="plain"}
The trackerfilter plugin has a 'filters' parameter with a /d option that allows a value to be selected from a drop down list so that all records with that value in the field are filtered out for presentation e.g a typical plugin might look like

~np~{trackerfilter filters="238/d" action="Create share holding report" noflipflop="y" trackerId="23" fields="238:244:240:241:242" compute="240/sum:242/sum" sort="y"}~/np~

But if field 238, as used in the example above, is an Item Link field the trackerfilter process does not find any records

This is a regression in both 11.x and 12.x but did work previously.


Other field types seem OK (although not tested them all !!!!)

assumed to be OK now


some while ago the trackerfilter plugin had an export option added to it so that tracker data could be exported from a wiki page

this involved the addition of additional parameters:

export_action="text" - creates an export button instead of the normal button with the text as a label and modifies the plugin behaviour
export_status="n" - exports the record status
export_created="y" - exports the creation date
export_modif="y" - exports the modification date
export_charset="UTF-8"} - sets the charset - default is UTF-8

A typical config could be:

~np~{trackerfilter trackerId="6" fields="30:31" noflipflop="y" export_action="Start the small CSV Download" export_status="n" export_created="y" export_modif="y" export_charset="UTF-8"}~/np~

Problems as of r46589:
* export of small/medium trackers (upto 1000 records tested) now are OK, but ..
* when attempting to export a 8000 record tracker with 20 fields, this 'breaks' after about 7000-odd records. What happens is that the first 7000-odd records in the downloaded spreadsheet are fine but the balance are then gobbledegook - but no error messages are shown

Also
* --when the plugin editor is used the four parameters: export_status,
export_created, export_modif, and export_charset are not recognised ie when editing an existing config they 'turn up' as italicised parameters in the list,-- THIS IS NOW FIXED

and

* because the normal use of this plugin has the filter parameter as mandatory the plugin editor screen will not close if this is not set - so it needs to accept that this isn't mandatory if the export_action has been set

Re-tested at 19th Aug 2013 (r47137)

Show site added on 22nd Aug 2013

r46077

At [http://dev.tiki.org/Bug Tracker List|Bug Tracker List] the first filter is "Area" (item link field) only "any" is displayed, area are missing.

The second field is "Sub-category" It show catId instead on name of the categories.

{syntax type="tiki" editor="plain"}
I originally stated the popup did not display correctly. Now it does not display at all.

In the show.tiki instance there are 5 fields in the tracker.
Only the first is listed using PluginTrackerFilter. The remainder are set to be displayed in a popup. But the popup does not appear.

I added the show.tiki instance before discovering a similar item. I've set that item in the "related to" field. It states that if the fields to be popped up are already listed, then the popup works. I tested this by adding the fields in the tracker filter. It did not help, so I rolled back the change.

It was mentioned that there is no point in displaying something in a popup that is already listed. So I tested including all the fields in the listing and using a pretty tracker to only display one. It did work this way either. This is the page that uses a pretty tracker:
http://hrsms-11204-3728.show.tikiwiki.org/tiki-ndex.php?page=ListWithPrettyTracker

{syntax type="tiki" editor="plain"}
trackeritemfield plugin doesn't have the same behavior as trackerlist plugin when it comes to rendering images:

Please see:
http://americana.org/Showing+TrackerItemField+IMage+Resize+Problem

trackeritemfield:
{trackeritemfield trackerId=14 itemId=2079 fieldId=256}

trackerlist:
{trackerlist trackerId="14" fields="256" showcreated="n" showfieldname="n" max="-1" itemId="2079"}

Show me all bug reports with priority >3
Show me all tracker items with modified date between X and Y
etc.



Related:
[Better reporting from tracker data|wish1980]

when filtering a tracker for a item-link field that is NOT set/linked, there is no output at all, no matter if there are tracker items with that item-link field set or not.

Example:
I have created two trackers
{img fileId="1611" thumb="box"}
{img fileId="1612" thumb="box"}

i have created three items in TestTracker1, two of them linked to TestTracker2, one item not linked.
{img fileId="1613" thumb="box"}

but if i filter for that not-linked item-link field, it just did not show up in TrackerList / TrackerFilter.

{img fileId="1614" thumb="box"}

here's the code
{img fileId="1615" thumb="box"}

by the way, in PluginList this problem does NOT occur, here the correct output is displayed.
{img fileId="1616" thumb="box"}
and the code of the PluginList
{img fileId="1617" thumb="box"}

I couldn't make trackerfilter and trackerlist plugins work with a tracker with mirror tables

We can now have filters for content of fields, but list of columns is not dynamic

Suggested by Abdelhak Fareh (INESSS)

Trackerlist plugin prevents the rest of the page from rendering.

Steps to reproduce:

1. Create a new tracker with Id 1
2. Add two trackerlistings with the same tracker id along with some garbage at the end of the page. An example page might look like this:

^
~np~{maketoc}~/np~


~np~!Design~/np~

~np~garbage here


~np~!Issue tracker~/np~

~np~!!Add an issue~/np~

~np~{TRACKER(trackerId=>1,fields=>1:2:3:4:5:6, action=>Add)}ITEM ADDED!!!!{TRACKER}~/np~


~np~!! View existing issues~/np~


~np~!!!Open issues~/np~
~np~{TRACKERLIST(trackerId=>1,fields=>1:2:3:5:6,
showtitle=>n,showlinks=>y,showdesc=>n,showinitials=>y,showstatus=>y,status=>o|p|op)} ~/np~


~np~!!!Closed issues~/np~
~np~{TRACKERLIST(trackerId=>1,fields=>1:2:3:5:6,
showtitle=>n,showlinks=>y,showdesc=>n,showinitials=>y,showstatus=>y,status=>c)} ~/np~



~np~garbage here.~/np~
^

3. Notice how the closed issues section doesn't even show up. Everything after the first trackerlist isn't shown.

On Tiki (tested on tiki21.4), in a tracker you can set a dropdown tracker field with a default value by setting twice the same value and you can set the label for the values: https://doc.tiki.org/Drop-Down---Radio-Tracker-Field

IE in the "Option" for the field (3 in our exemple):
NO=Nouveau,NO=Nouveau,PE=En Attente,CL=Ferme

This is working fine.

On a wiki page you can use then a tracker list plugin to list the item like:
{CODE(caption="Work")}
{trackerlist trackerId="1" fields="1:2:3" filterfield="3" exactvalue="PE"}
{CODE}
This will work.

However if you try to filter using the default dropdown value it won't work anymore (was working on Tiki18)
{CODE(caption="Doesn't work")}
{trackerlist trackerId="1" fields="1:2:3" filterfield="3" exactvalue="NO"}
{CODE}

This is a regression on Tiki21.4
Work on Tiki23

UPDATE: I was doing it wrong! :)
Syntax should look like: ~np~{TRACKERLIST(trackerId=1 filterfield="2:1" exactvalue="d2v1:d1v1")}{TRACKERLIST}~/np~, with each group of arguments passed as a single string.

Also, I'm going to update documentation so it says use ":" instead of "|" like it says to use.


Unable to filter trackerlist on multiple values, or I'm doing it wrong.

[value to filter x by|As per documentation], using plugin trackerlist you need to have arguments for filterfield and filtervalue or exactvalue to filter the trackerlist by a value in a field.

My understanding is that you provide fields for filterfield as filterfield=x:y to filter values for field x and y, and then exactvalue="value to filter x by"|"value to filter y by"

The documentation says you use a pipe to separate the exactvalue parameters, which if true is inconsistent with the use of ":" everywhere else, and also does not seem to be the case based on the code here from -+wikiplugin_trackerlist.php+-/

{CODE()}if (isset($_REQUEST['reloff']) && empty($_REQUEST['itemId']) && !empty($_REQUEST['trackerId'])) { //coming from a pagination
$items = $trklib->list_items(
$_REQUEST['trackerId'],
$_REQUEST['reloff'], 1, '', '',
isset($_REQUEST['filterfield']) ? preg_split('/\s*:\s*/', $_REQUEST['filterfield']) : '',
isset($_REQUEST['filtervalue']) ? preg_split('/\s*:\s*/', $_REQUEST['filtervalue']) : '',
isset($_REQUEST['status']) ? preg_split('/\s*:\s*/', $_REQUEST['status']) : '',
isset($_REQUEST['initial']) ? $_REQUEST['initial'] : '',
isset($_REQUEST['exactvalue']) ? preg_split('/\s*:\s*/', $_REQUEST['exactvalue']) : '',
$filter
);
{CODE}

I don't know much about regular expressions, but I see ":" in there.

Anyhow, syntax like
{CODE()}{TRACKERLIST(trackerId=5 fields=18:23:22 filterfield=32:32 exactvalue="val"|"val2")}{TRACKERLIST}{CODE}
or
{CODE()}{TRACKERLIST(trackerId=5 fields=18:23:22 filterfield=32:32 exactvalue="not(val)"|"not(val2)")}{TRACKERLIST}{CODE}
(using "|" or ":") doesn't seem to work.

I'm going to demonstrate/test to make sure this is the case on 11.1, and update if it is.

I tested today the plugin helper ui to select fields in plugin trackerlist, but I had no way to get my typing stored/saved in the page for the "fields" param: numbers got lost when clicking elsewhere, and text (field names) didn't make any matxh in the dropdown.
This used to work with no problems in the past (Tiki15 LTS at least).
Editing by hand in the wiki textarea (aside of the plugin popup helper ui) worked as expected for the param "fields" in plugin trackerlist, but new users got confused aboput why that text input/dropdown for "fields" in plugin trackerlist didn't work in the popup helper.