Table Transformer WHERE clause doesnt work

[Nick Frazier]

Version = v9.12.1

On a single page I have 4 tables of the same structure (Team,Task, Description, Target).  On the parent page to that I'm trying to write a query that merges all of them and filters by Target fields. 

This is the query I'm using.  

SELECT * FROM T* WHERE "Target" = "Q4"

The issue is the result "The query returned no rows." when I know one of the subtables has that value.

[Stiltsoft support · Accepted solution]

Hi @Nick Frazier ,

The first thing that caught my eye is "Target" = "Q4".

If you refer to a column, you use 'Column_name'.

If you refer to a string, you use "Some_string".

Seems that you should change your query as:

SELECT * FROM T* WHERE 'Target' = "Q4"

[Nick Frazier]

D'oh.  That fixed it! Thanks.  I'm used to python where " and ' are interchangeable.