Hi Community, I’m new to Grafana so I would need your help on below query We are using sqlite datasource to build dashboards. we are getting data with below query but we want to filter it based on time range and also real time data. ex: every 6m the dashboard to be refresh and change the values. So, can some one help me to how we can pass the time interval of 6m in query to refresh it every time. Select Date_n_Time, SensorID, Temperature from dht22_temperature_Data Thank you in advance! Regards, Eshwar

[image] How to pass timerange filter for postgres query Dashboards Problem Statement : We are using sqlite datasource to build dashboards. we are getting data with below query but we want to filter it based on time range and also real time data. ex: every 6m the dashboard to be refresh and change the values. So, can some one help me to how we can pass the time interval of 6m in query to refresh it every time. Select Date_n_Time, SensorID, Temperature from dht22_temperature_Data Step to achive this follow the steps mention below Step 1: Create table and inser… Follow the steps

Welcome @eshwar6264 to the Grafana forum. [image] eshwar6264: we want to filter it based on time range Here’s the docs on how to incorporate the Grafana time picker into your SQL query. SQLite is not explicitly mentioned, but I believe it will be either WHERE $timeFilter or WHERE $__timeFilter [image] [image] eshwar6264: also real time data. ex: every 6m the dashboard to be refresh and change the values You can select the auto refresh interval of 5m here: [image]

Hi @grant2, I had tried to give $timeFilter or $__timeFilter in where condition but I am getting below error. SQL logic error: near “)”: syntax error (1) Data for date is in unix timestamp and I am converting it into datetime format even though it is throwing an error. If you have any other suggestions please let me know. it’s working in below condition but when I use getting above error [image] [image] [image] Regards, Eshwar

Just try $__timeFilter(date_n_time)

How to pass timerange filter for Sqlite query

Grafana Dashboards

infofcc3 January 20, 2025, 1:20pm 5

Follow the steps

Topic		Replies	Views
How to pass timerange filter for postgres query Dashboards	2	703	January 27, 2025
Time range query Configuration	3	2566	May 6, 2021
Absolute Time Range in SQL Query Grafana time-selection	1	1712	August 7, 2023
How to dynamically set the date range from grafana to my mysql query MySQL query-help , dashboard	2	20474	January 8, 2023
Time Filter components not responding completely Grafana	5	714	July 11, 2018

How to pass timerange filter for Sqlite query

Related topics