Using a flow variable as value in DB Delete (filter) connector

[manugor]

I want to delete all rows in the database that have a date which I have in an flow variable
I have no problem connecting the database and entering the value by hand, but want to use a varibale.
¿How?

[ricardo_martins]

You can try to use the DB SQL Executor node and type the code like this:

USE almoxarifado_app;

DELETE FROM almoxarifado
WHERE almoxarifado = ‘$${variable}$$’

With the variable name into single quotation marks. I think it will work (please use a test data before do it, haha)

[ricardo_martins]

By the way, in my example I have the table almoxarifado with a column called almoxarifado too, hahaha

[manugor]

will try it, seems sensible
thanks

[manugor]

Worked perfectly, thanks