You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Trying to create a query that gets a date and time range filter as a parameter, I noticed that the counter was different than doing it directly within the DB.
The problem is that the filter doesn't use the time at the end threshold. It is filtering out all the records with date time which the date is later than the date end of the range.
It should include in the result the records with the same date and below the time at that threshold.
Example:
query using range date and time:
After changing the end threshold of the range one minute more what changes the day, all the records from the previous day appear
Steps to Reproduce
Use the Query results source which will give you sqlite env.
Create a query that filters records using data and time range as a parameter in the form
select
createdAt
from
cached_query_3
WHERE
createdAt BETWEEN '{{ Range.start }}'and'{{ Range.end }}'order by
createdAt
Fix the end threshold of the range with a time that will include records from the day of it. EG: {day} 23:59
See that in the results there are only records before {day}, none of the records during that day appear.
Issue Summary
Trying to create a query that gets a date and time range filter as a parameter, I noticed that the counter was different than doing it directly within the DB.
The problem is that the filter doesn't use the time at the end threshold. It is filtering out all the records with date time which the date is later than the date end of the range.
It should include in the result the records with the same date and below the time at that threshold.
Example:
query using range date and time:
After changing the end threshold of the range one minute more what changes the day, all the records from the previous day appear
Steps to Reproduce
Query results
source which will give you sqlite env.{day} 23:59
{day}
, none of the records during that day appear.Technical details:
The text was updated successfully, but these errors were encountered: