# MySql select filter

**URL:** <https://discourse.nodered.org/t/mysql-select-filter/46858>\
**Category:** General\
**Created:** [8 June 2021 12:16 UTC](https://discourse.nodered.org/t/mysql-select-filter/46858 "2021-06-08T12:16:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![simone\_alfa](https://avatars.discourse-cdn.com/v4/letter/s/ba9def/32.png) [@simone\_alfa](https://discourse.nodered.org/u/simone_alfa)\
**Post date:** [8 June 2021 12:16 UTC](https://discourse.nodered.org/t/mysql-select-filter/46858/1 "2021-06-08T12:16:45Z")

</div>

Hi,  
I'm new of Node-Red.

I want to filter a data table of mysql database with 2 date picker, but I don't success to read the previous variables of function.

 ![Cattura](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/0/40ff077671ceb7f09eb1f7245930972175fee6ad.png)

 ![Cattura2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/b/ebd158ac65f3be29e4abce6f1ebc0efd7195793c.png)

Someone can help me?  
Thank you

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [8 June 2021 13:17 UTC](https://discourse.nodered.org/t/mysql-select-filter/46858/2 "2021-06-08T13:17:47Z")

</div>

Use a join node before the function node to ensure both values are in the `msg` entering the function.

Use the join node in key/value mode.

See [this article in the cookbook](https://cookbook.nodered.org/basic/join-streams) for an example of how to join messages into one object.

---

<div class="post-metadata">

**Author:** ![simone\_alfa](https://avatars.discourse-cdn.com/v4/letter/s/ba9def/32.png) [@simone\_alfa](https://discourse.nodered.org/u/simone_alfa)\
**Post date:** [8 June 2021 14:05 UTC](https://discourse.nodered.org/t/mysql-select-filter/46858/3 "2021-06-08T14:05:51Z")

</div>

Thank you so much!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [7 August 2021 14:06 UTC](https://discourse.nodered.org/t/mysql-select-filter/46858/4 "2021-08-07T14:06:45Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.