Table Transformer Where Clause Not Working

Question

Hi, please help. A simple query.

SELECT COUNT(T1.'Key') AS 'Open' 
FROM T1 
WHERE T1.'Status' IN ("TO DO", "IN PROGRESS", "BACKLOG")

OR

SELECT COUNT(T1.'Key') AS 'Open' 
FROM T1 
WHERE T1.'Status' = "TO DO"

both do not work. I get nothing.

However, this works!!! Why?

SELECT COUNT(T1.'Key') AS 'Open' 
FROM T1 
WHERE T1.'Status' LIKE "%IN PROGRESS%"
OR T1.'Status' LIKE "%TO DO%"
OR T1.'Status' LIKE "%BACKLOG%"

Katerina Kovriga _Stiltsoft_ · Accepted Answer

Hi @Leona,

The first two queries work well if you change the names of your statuses: for example, TO DO -> To Do, IN PROGRESS -> In Progress.

Please see the screenshots below and check the queries - I specifically made the status names visible near the preview window:

And the third query catches all the suitable names without the lower/uppercase check.