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%"
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.