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