Loading...
 
Skip to main content

Report doesn't filter by date

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Report doesn't filter by date
Version
9.x
Category
  • Consistency
  • Error
Feature
Calendar
Report
Trackers
Resolution status
Won't Fix
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro
Rating
(0)
Description

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+FieldsQuestion

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?

Importance
6
Easy to solve?
5
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
4325
Created
Tuesday 30 October, 2012 10:36:08 UTC
by Xavier de Pedro
LastModif
Sunday 10 October, 2021 03:03:08 UTC


Show PHP error messages