Category: Report

I've added a test Report with the bug tracker sample data, seems to work fairly well, except that it's not listing open items (which trackerlist does).

Robert, maybe there is some bug around also for those simple examples?

Compare this:
http://demo.tiki.org/9x/Bug_Tracker#Bugs_list_using_Plugin_Tracker_List_

with that:
http://demo.tiki.org/9x/Bug_Tracker#Bugs_list_using_Plugin_Report_

Some fields display html code in the spreadsheet cells:
Like:

{CODE()}
Identificació - 319 ItemId - 320
<span class="hdrField" data-level="3" style="display:none;"></span> 1596
...
{CODE}

See screenshot here:
{img src="display66"}

The first column is a self-numbering field type, as main field (linked from the list to the item), and the one that says "Etiquetes lliures" refers to tags, which show hyperlinked tags, etc.
---
UPDATE: Still happening in 12.x {sign user="xavi" datetime="2013-11-17T08:47:04+00:00"}

Report doesn't seem to filter by date as it's supposed to do.

I select to list only values after a date (by the way, how does report know that this field is supposed to be the start date? just because is the first one of a couple of consecutive date fields in a tracker?), and value before that date are also shown.

I mean, we have a tracker with several date fields (4 in fact) for project management:
* when the project was requested
* when the project started
* when the project is due to be finished
* the date of the next deadline to meet within the project timeframe.

Ideally, the user should be offered the option to select which tracker field want to use as a start date for the filter, and which one as the end date for the filter. And not just the creation date or the modification date.

Right now, it seems to be using either the creation or modification date of the tracker item? (which is less useful and less versatile than what it could be with the previous improvement of the design)

The other things that might be affecting the missbehavior of the filtering by date is that the date field in a tracker can be set either by using the "Date and time" tracker field, and the "Date and time (Date Picker)" (jquery) tracker field.
See http://doc.tiki.org/Date+Tracker+Fields

They both seem (from the end user point of view) to have different way to store data:
* JQuery date picker from the tracker-field "Date and time (Date Picker)" seems to use this syntax for dates: __yyyy-mm-dd__
* JQuery date picker from the Report Builder (tiki-edit_report.php) Start and End dates, seems to use this syntax for dates: __dd/mm/yyyyy__

Maybe this is also interfering in the filtering by dates?

Fatal error: Maximum execution time of 300 seconds exceeded in /path/lib/smarty/libs/sysplugins/smarty_internal_data.php on line 54

Using report plugin, with a tracker with many data, etc
Ask xavi if you want to see the code to reproduce it, or a db dump to reproduce it in your localhost.

The Report feature doesn't seem to filter data if the filter applid refers to a "Item link" type of tracker field.

Scenario:
* Tracker 1 refers to a user tracker, and one of the fields is for province.
* Tracker 2 contains all the provicen names in a drop down field, and cities in a text field. (this is the common setup of a "dynamic items list" featur).

If you use report to list all items from tracker 1 which contain "province name" = "foo", you get nothing in the list. foo province exists in tracker 2. However, mysql table for tracker data seems to store the value for the province with a numeric id, instead of the string "foo" that the user knows. Therefore, there no way for the user to filter for that field.

Features Classification

Contributors