SQL Code: DELETE using instance variable

[TJFORCE68]

I want to delete from a schema abcMySchema. 

In this schema I am storing the Label of the workflow: MyWorkflow.

I have added a SQL Code Action: DELETE FROM abcMySchema WHERE sWorkflowName = <%= instance.label %>;

I am getting the following errors:

PGS-22000 PostgreSQL error: ERROR: column "myworkflow" does not exist...

WDB-200001 SQL statement 'DELETE FROM abcMySchema WHERE sWorkflowName = MyWorkflow' could not be executed.

I can hardcode the value WHERE sWorkflowName = 'MyWorkflow' and the query runs and deletes the associated records.

How do you use the dropdown instance > label in a query?

[Amine_Abedour · Accepted solution]

Hello @TJFORCE68 ,

Try this : 

DELETE FROM abcMySchema WHERE sWorkflowName = '<%= instance.label %>';

Br,

Amine

[TJFORCE68]

I thought I tried this since it is a string and was getting errors.  This worked for me.  Thanks.