AS Statement

[Nate Dickinson]

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? 

[Evgenii · Accepted solution]

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...

[Nate Dickinson]

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!