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

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.

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)

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

1 Like

will try it, seems sensible

Worked perfectly, thanks

1 Like

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