Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query builder: Unable to filter based on timespan or datetime ranges #457

Open
andresmgot opened this issue Aug 25, 2022 · 0 comments
Open
Labels

Comments

@andresmgot
Copy link
Contributor

andresmgot commented Aug 25, 2022

What happened:

The builder quotes timespan or datetimes when comparing them in a filter. This syntax is only valid with the operators that compare exact values (e.g. == or !=) but it does not work with ranges:

Screenshot from 2022-08-25 16-55-15

To compare ranges, we need to explicitly convert them to the type, for example:

| where Duration > timespan('00:00:01')

What you expected to happen:

How to reproduce it (as minimally and precisely as possible):

Screenshots

Anything else we need to know?:

Environment:

  • Grafana version:
  • Plugin version: 4.1.5
  • OS Grafana is installed on:
  • User OS & Browser:
  • Others:
@andresmgot andresmgot added type/bug Something isn't working datasource/ADX labels Aug 25, 2022
@andresmgot andresmgot moved this to Incoming in Partner Datasources Aug 25, 2022
@andresmgot andresmgot moved this from Incoming to Backlog in Partner Datasources Aug 25, 2022
@andresmgot andresmgot moved this from Backlog to Incoming in Partner Datasources Aug 25, 2022
@andresmgot andresmgot changed the title Query builder: Unable to filter based on timespan Query builder: Unable to filter based on timespan or datetime Aug 25, 2022
@andresmgot andresmgot changed the title Query builder: Unable to filter based on timespan or datetime Query builder: Unable to filter based on timespan or datetime ranges Aug 25, 2022
@yaelleC yaelleC moved this from Incoming to Backlog in Partner Datasources Aug 26, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Backlog
Development

No branches or pull requests

2 participants