AS Statement

Nate Dickinson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2023

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? 

1 answer

1 accepted

0 votes
Answer accepted
Evgenii
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 12, 2023

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2023

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! 

Like Evgenii likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events