# Filter data SqlLite in table
**URL:** https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269
**Category:** General
**Tags:** node-red-dashboard, database
**Created:** [13 April 2022 22:18 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269 "2022-04-13T22:18:13Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@eruiz](https://discourse.nodered.org/u/eruiz)
#### Post date: [13 April 2022 22:18 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/1 "2022-04-13T22:18:13Z")
Hello good afternoon, I tell you what I want to do, filter a database by temperature and date, currently I show all the data in a table, but I want to filter it, I know what sentence using a sentence like: "select \* from 'database' where 'temperature = 15', it will be filtered, but what I'm looking for is that I don't write the filter temperature, if I don't give it to a variable for example, thank you very much, I attach my flow.
[flows (1).json](https://discourse.nodered.org/uploads/short-url/aZmRqaXFelEDwISX3IOL5evmgmO.json) (79.7 KB)
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [14 April 2022 11:29 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/3 "2022-04-14T11:29:39Z")
So why not use the date in stead of the temperature in your ‘where’ clause?
---
### Author:  [@eruiz](https://discourse.nodered.org/u/eruiz)
#### Post date: [14 April 2022 13:09 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/4 "2022-04-14T13:09:13Z")
Of course I can do that, but what I want to do is that in a date node or tex input node, enter date or date data and filter dynamically, all those filters do it from the UI
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [14 April 2022 13:58 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/5 "2022-04-14T13:58:12Z")
Do you mean you want to enter a date on the dashboard and press enter, then use that date in the where clause?
---
### Author:  [@eruiz](https://discourse.nodered.org/u/eruiz)
#### Post date: [14 April 2022 18:57 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/6 "2022-04-14T18:57:55Z")
yes, that's exactly what I want to filter both by date and perhaps temperature values in the same statement.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [14 April 2022 22:27 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/7 "2022-04-14T22:27:16Z")
> [@eruiz](#):
>
> I want to filter both by date and perhaps temperature values in the same statement.
Well you could build the sql statement using switch nodes to decide if you want date, temperature or both ad then use a template node to build the statement.
You will have to decide what the conditions re that you will use. I'd suggest using the `ui-form` node to enter the date and/or temperature they both would be in the msg and you could then create your select statement based on which item(s) are filled in.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [13 June 2022 22:27 UTC](https://discourse.nodered.org/t/filter-data-sqllite-in-table/61269/8 "2022-06-13T22:27:17Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.