AS Statement

Question

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 Answer

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