Bug #6414
closedTimeline pre-generated time bounds are not respected
0%
Description
The timeline form is loaded with a pre-defined time interval bounds, based on current hour. These bounds are then not used and the results are given for a superinterval since midnight before lower bound until midnight after upper bound.
Example:
Detection time from: 2020-06-30 15:00:00
Detection time to: 2020-07-07 15:00:00
Actual query:
SELECT generate_series('2020-06-30T00:00:00'::timestamp, '2020-07-08T00:00:00'::timestamp, '0 days 3600.000000 seconds'::interval) AS bucket ORDER BY bucket
The results match the time interval in the query, so the bounds as shown in the form are not respected.
Updated by Radko Krkoš over 4 years ago
After more testing, this seems intentional, the interval is extended to a full week.
Updated by Jan Mach over 4 years ago
- Status changed from New to Feedback
- Assignee changed from Jan Mach to Radko Krkoš
Radko Krkoš wrote in #note-1:
After more testing, this seems intentional, the interval is extended to a full week.
This indeed is a feature, not a bug. Whether it is optimal solution is up for a debate, since it got you confused, maybe the thresholds set by the user should be enforced. However the idea was to present user with nicely rounded time intervals, which means sometimes the thresholds need to be increased to be able to use nice time bucket sizes.
Updated by Radko Krkoš almost 4 years ago
- To be discussed changed from Yes to No
Updated by Radko Krkoš almost 4 years ago
- Status changed from Feedback to Deferred
- Assignee deleted (
Radko Krkoš)
No decision was made one way or the other, currently there are more pressing issues. Deferring.
Updated by Radko Krkoš about 2 years ago
- Assignee set to Jakub Maloštik
- Target version changed from Backlog to 2.11
As discussed on the meeting, timeline looks like a good place to start hacking Mentat right now.
Updated by Jakub Maloštik almost 2 years ago
- Status changed from Deferred to In Progress
Updated by Jakub Maloštik almost 2 years ago
- Status changed from In Progress to Resolved
Updated by Rajmund Hruška almost 2 years ago
- Status changed from Resolved to In Review
Merged into devel and deployed on mentat-alt.
Updated by Rajmund Hruška over 1 year ago
- Status changed from In Review to Closed