List, range filter; some date arguments are working for modification_date but not for creation_date
- Status
- Open
- Subject
- List, range filter; some date arguments are working for modification_date but not for creation_date
- Version
- 25.x
26.x
master - Category
- Conflict of two features (each works well independently)
- Consistency
- Feature
- Search
Trackers
Wiki Plugin (extends basic syntax) - Resolution status
- New
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
On a Tiki25 I have tracker items created yesterday and today.
If I set a plugin List and filter using "day" argument to filter a date range it is working as expected for the "modification_date" but not for the "creation_date".IE: These are the dates outputted by tiki-pluginlist_experiment.php
modification_date => "2023-02-28 06:01:22"
creation_date => "2023-02-27 14:05:01"If I use
{filter range="modification_date" from="-2 day" to="-1 day"} it will output the itemsIf I use
{filter range="creation_date" from="-2 day" to="-1 day"} 0 results
(I also tried from="-3 day" to be sure it was not a timezone issue) 😉Both should work the same.
- Workaround
As workaround for this specific case (won't work if I need -4 days), I can use
{filter range="modification_date" from="yesterday" to="now"}
{filter range="creation_date" from="yesterday" to="now"}Or
Create an extra date field
- Importance
- 3
- Easy to solve?
- 5
- Priority
- 15
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 8349
- Created
- Tuesday 28 February, 2023 06:29:54 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Tuesday 28 February, 2023 06:31:48 UTC