Table Transformer WHERE clause doesnt work

Question

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 Answer

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"