Hi,
There are issues with filtering on 'Date and Time picker' in TableSorter and PivotTable. I spoke with another team member who said they were "deep issues". I have confidence they will get solved some day, but date sorting, - by month and year, at least - is a basic necessity today.
I created a very simple workaround that is bullet-proof, which works across the board where applied. I added two dropdowns with:
1) year, i.e. '2019, 2018', etc.
2) month, i.e. '01-January, 02-February, etc.'
So now the user has two extra fields to click on (in addition to the 'Date and Time picker' field, as the day is important also) but, also have a TableSorter that works 100%
The 'Wish' would be to add separate fields ('months', 'year') in which:
month - has an option to have the current calendar month (based on the time and date settings off the users Tiki configuration) be the default option (yes/no)
date - same thing, option to have current year as default.
While some would argue, why not 'quarterly' or some other options, realistically, monthly or annualy is how the vast majority people view reports.
I strongly suspect this would be super easy and quick to accomplish as 90% of the code is already available.
br,
Mike
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |