Does anyone have a workaround for writing an AS statement in JQL? Here is my use case.
For reporting issues to a confluence dashboard:
I'd like to show a calculation of issues in each status in the following way:
Critical=Critical
Highest/High= High
Medium/low = Medium/Low/Lowest
Blocked=Blocked
If this were SQL I could just write an AS statement and be done with it. The only workaround I've found is to make a jira macro showing a count, and then adding my own custom label beside the number. Does anyone else have any other ideas?
Hi, @Nate Dickinson
Sorry, but JQL is not so rich, like SQL.
You can use workaround, with 4 filters, with JQL like:
project = ZZZ AND priority = Critical
project = ZZZ AND priority IN (Highest, High)
project = ZZZ AND priority IN (Medium, Low, Lowest)
and so on...
Name them in confluence as you like...
Thanks Evgeniy, That's what I'm doing. It's just a bummer because it's 4 JQL statements I need to write for each sub business unit. So 100+ Queries to recreate a table. Fun!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.