Category: Trackers

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"}
On Tiki29 from upgrade using the UAB the default modules displays a "Recent Tracker Items" module.
Where it was displaying the "text" values of an item it displays now the itemlink ID which is not useable.

See screen shot:
{img fileId="3172" thumb="box"}

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

{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"}

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

Suggested by Abdelhak Fareh (INESSS)

When using TrackerList compute function (sum of a column), sometimes it returns the number: 7.105427357601E-015

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

This is reported on several php forums and is not a bug but: "its the acceptable precision of floating point numbers" or also described as "Subtracting 2 floats returns incorrect results".

Seems that a workaround patch may be necessary as one post suggests:
"so I guess you need to hack it: if ($resultB < 0.000) $resultB = 0;"

Here are links:
http://forums.oscommerce.com/topic/199647-php-math-bug-big-problem/

https://bugs.php.net/bug.php?id=41213&edit=1

http://grokbase.com/t/php/php-bugs/074v5dv79q/41213-new-subtracting-2-floats-returns-incorrect-results

br,
Mike

Admins and other groups can see all tracker items if status="opc" is set, while an anonymous user can only see the open items.
TW5.0Beta1

Example:
~np~{trackerlist trackerId="1" fields="23:11" sort="y" showtitle="n" showlinks="y" showdesc="n" showinitials="n" showstatus="y" showcreated="y" showlastmodif="y" showfieldname="y" showitemrank="n" status="opc" sort_mode="lastModif_desc" max="10" showpagination="n" filterfield="43" filtervalue="C" ignoreRequestItemId="y" silent="n"}~/np~

The open and closed issues are fine.

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.

To see example, go to
http://hrsms-11204-5084.show.tikiwiki.org

There are two trackers.

Tracker1 is for books, with title, author, publisher and date.

Tracker2 is for owners of the books. It ties an owner ID to the book ID.
''In my actual case, the tracker has a user field type and the "My Books" page filters based on the current user. To simplify the problem for demonstration, the owner field is a simple numeric type and there is no user field in tracker2.''

There are 6 entries in tracker 1.
The entries in tracker 2 are for two people John (owner #1) and Jane (owner #2).

Go to http://hrsms-11204-5084.show.tikiwiki.org/tiki-index.php?page=Book+Owners and click on John or Jane below to see the books they own. Each has four of the six books. But when using a trackerlist inside a pretty tracker, only one item is returned. There is no change whether or not the inner trackerlist also uses a pretty tracker.

Create a group and put that group as tracker admin of a particular tracker (through individual tracker perms). This group should not have global tiki_p_admin_trackers.

Even though a user in that group can edit the field set as isHidden, i.e. only admin can view, through tiki_view_tracker_item.php (correct behaviour), the tracker list plugin won't show the field for him (wrong behavior).

{syntax type="tiki" editor="plain"}
TW5.0beta1
Fields=X:Y
Filterfield=Z
shows a table with X:Y:Z
with Z having obviously all the same values

{syntax type="tiki" editor="plain"}
Just see ((All Patches)): content that is to be mouse-overed is breaking the page.

And on ((DogFood)), there is no mouse-over

As discussed during the webinar.

See http://dev.tikiwiki.org/TestTrackerlist

You will see that links do not how on the first trackerlist plugin. They work on the second and third one though.

Removing description from the fields shown in the popup seems to fix it. But not all descriptions seem to break it though - see the second plugin filtered differently which works.

{syntax type="tiki" editor="plain"}
Using Popup inside plugin trackerlist sends a very big & faulty html to the browser. The file for a tracker of less than 20 rows has 80 MB.
FF, IE and Chrome have big problems with it.
Sometimes a crippled table is shown, sometimes nothing.
Heavy load on cpu.
To let it be not too easy:
The same setup worked for a while. But now it produces always the same problem on 3 browsers on 2 computers.

I could upload the html-file if someone wants to see it. It contains kind of valid start but somewhere has tons of ////. Seems to be some recursive content.

trackerlist trackerId="1" fields="1:12:6:9" popup="7" showlinks="y" showstatus="y" status="opc"

Version 6.2 german

{CODE(caption="Current")}
{TRACKERLIST(trackerId=>1,fields=>1:2:3, filterfield=>1, filtervalue=>"A")}{TRACKERLIST}
{CODE}


{CODE(caption="Suggested")}
{TRACKERLIST(trackerId=>1,fields=>1:2:3, filterfield=>1, filtervalue=>"A" or "B")}{TRACKERLIST}
{CODE}

The following code would show the value for tracker item ID #62:
{CODE()}
{TRACKERLIST(trackerId=>7,fields=>59,itemId=>62)}{TRACKERLIST}
{CODE}

We don't always need the field names when using a trackerlist. Especially if we are just listing one field.

A new parameter could be added:

showfieldname=>y|n default to yes (which is current behavior)

This could be used in conjunction with [tiki-view_tracker_item.php?itemId=938|Trackerlist Plugin: get results for a specific tracker item ID]. In which case, the following code could be used in a wiki page to show the value of field #59 for tracker item ID #62:
{CODE()}
{TRACKERLIST(trackerId=>7,fields=>59,itemId=>62,showfieldname=>n)}{TRACKERLIST}
{CODE}

Wiki pages could be built to include these dynamic fields. And the values could be updated via the tracker. A bit like the dynamic variables feature.

{syntax type="tiki" editor="plain"}
Seen problem on ! and ^

Ex.:
http://dev.tikiwiki.org/tiki-index.php?page=WYSIWYG

As seen here:
http://dev.tikiwiki.org/tiki-pagehistory.php?page=All%20Bugs&compare=1&oldver=18&newver=19&diff_style=minsidediff

I would like a trackerlist plugin report with a list of all bugs which are in category 56, 172, 57 or 174.

In some other cases, I would like a trackerlist report which intersects two categories (ex.: bugs and 1.9x)