Display one row using table transformer macro?

Jessica Luo

I have the above table and I want to use the table transformer macro to only display the "complete' row. 

I tried to use a custom SQL query in the table transformer macro but it is not behaving how I expected.

 

I am using this query:

 

SELECT * FROM T1 WHERE 'STATUS' = 'COMPLETE'

Katerina Rudkovskaya _Stiltsoft_

Hi @Jessica Luo,

Please use the following query:

SELECT * FROM T1 WHERE 'STATUS' = "COMPLETE"
As you refer to the value (string) and not the column, you should use not ‘COMPLETE’ but "COMPLETE" in your query.