How to use variable in Database reader

Hi all,

I am new at KNIME. Is it way to access a variable in Database Reader? Like the following setting in the field of SQL Statement:

 

Select *

From compound_table ct

Where ct.name = $variable

Yes, this works, and it also works for Reader nodes. You just need to enable the flow variable ports on the context menu of this node and then drag a variable connection onto this node. For an example see our public server, category 004_Databases, workflow 004001_Database_SimpleIO.