The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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.
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.