Category: Report

php console.php index:rebuild works well

However, it doesn't give any feedback.

The web interface reports:

wiki page: 2850
blog post: 4
article: 1708
file: 4321
trackeritem: 6988
comment: 13

Execution time: 510.07 secs
Memory usage: 116.50MB
Queries: 245172 in 163. secs
Last update from SVN (12.0svn): Friday 02 of August, 2013 11:11:40 EDT- REV 46958

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.

This tracker is made to help filtering and sorting the features vs categories vs options we need to tag a bug/regression/wish with.

Using trunk as of r53746 from 2015-2-3.
When clicking "Reports" and then select "Type: Logs" and the just click preview nothing happens except the hourglass.

Reason is: request to tiki-ajax_services.php responds with internal server error 500.

Detail from Debug Console in Chrome
{CODE()}
Request URL:xxx.xxx.xxx.xxx/tiki-ajax_services.php
Request Method:POST
Status Code:500 Internal Server Error
Form Data:
controller:report
action:preview
value[0][name]:logs
value[0][value]:category
value[1][name]:logs_action
value[1][value]:
value[2][name]:logs_start
value[2][value]:
value[3][name]:logs_end
value[3][value]:
value[4][name]:logs_fields[]
value[4][value]:actionId
value[5][name]:logs_fields[]
value[5][value]:action
value[6][name]:logs_fields[]
value[6][value]:lastModif
value[7][name]:logs_fields[]
value[7][value]:object
value[8][name]:logs_fields[]
value[8][value]:objectType
value[9][name]:logs_fields[]
value[9][value]:user
value[10][name]:logs_fields[]
value[10][value]:ip
value[11][name]:logs_fields[]
value[11][value]:comment
value[12][name]:logs_fields[]
value[12][value]:categId
value[13][name]:logs_fields[]
value[13][value]:client
value[14][name]:logs_grouping
value[14][value]:
value[15][name]:logs_sort
value[15][value]:
value[16][name]:logs_limit
value[16][value]:
type:Logs
{CODE}

Excerpt from apache error.log:
{CODE()}
[Wed Feb 04 00:02:24.195245 2015] [:error] [pid 16574] [client x.x.x.x.:50339] PHP Fatal error: Call to undefined method TikiSheet::setSize() in /var/www/html/tiki/lib/sheet/grid.php on line 1153
{CODE}