# How to pass timerange filter for Sqlite query **URL:** \ **Category:** Dashboards\ **Tags:** dashboard\ **Created:** [November 17, 2023, 5:35am UTC](https://community.grafana.com/t/how-to-pass-timerange-filter-for-sqlite-query/108006 "2023-11-17T05:35:21Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![infofcc3](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/infofcc3/32/51248_2.png) [@infofcc3](https://community.grafana.com/u/infofcc3)\ **Post date:** [January 20, 2025, 1:20pm UTC](https://community.grafana.com/t/how-to-pass-timerange-filter-for-sqlite-query/108006/5 "2025-01-20T13:20:35Z")
> [@How to pass timerange filter for postgres query](https://community.grafana.com/t/how-to-pass-timerange-filter-for-postgres-query/140762): > > 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 --- _[View the full topic](https://community.grafana.com/t/how-to-pass-timerange-filter-for-sqlite-query/108006)._