# SQL Query Filter options

**URL:** <https://forum.inductiveautomation.com/t/sql-query-filter-options/70217>\
**Category:** Ignition\
**Created:** [February 23, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/sql-query-filter-options/70217 "2023-02-23T12:26:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Divya\_Chorge](https://avatars.discourse-cdn.com/v4/letter/d/f05b48/32.png) [@Divya\_Chorge](https://forum.inductiveautomation.com/u/Divya_Chorge)\
**Post date:** [February 23, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/sql-query-filter-options/70217/1 "2023-02-23T12:26:42Z")

</div>

I am logging the data from SQL Server Database into the timeseries chart but I wanted to display only one day value on chart and after completing one day it should get refreshed. What SQL Query should I use to filter only one day as I want to show only one day value and for next day the chart should get refreshed.

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [February 23, 2023, 3:11pm UTC](https://forum.inductiveautomation.com/t/sql-query-filter-options/70217/2 "2023-02-23T15:11:20Z")

</div>

What kind of query it is?

And where are you putting this query?