azure-data-explorer-datasource icon indicating copy to clipboard operation
azure-data-explorer-datasource copied to clipboard

Published 20 hours ago • verified publisher icon grafana

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

Open andresmgot opened this issue 3 years ago • 0 comments

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 avatar Aug 25 '22 14:08 andresmgot