SQL language to JQL help for renaming data in JIRA Dashboard.

[Aaron Butler]

Hello,

I'm trying to create a Custom Dashboard report for my weekly sprints. 

Currently using this saved filter for my charts as working with Epic Links for JIRA tickets system.

project = "Careers Platform Engineering" AND Sprint in (openSprints()) AND type in (standardIssueTypes()) ORDER BY "Epic Link"

I really want to add this line of SQL code to help with the naming of my pie charts. but, not sure how to do it in JQL.

Select case epic WHEN epic is null THEN 'Unplanned' WHEN epic in (NCSD-xxx) THEN 'Service Improvment' ELSE 'Project Delivery' END

Is it possible to change the name on the graphs on JIRA dashboards?

Thanks

Aaron

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the community!

JQL is not SQL, all it does is find issues that match patterns on those issues.  There are no case, if, calculate, etc functions.  Those things go in to the reports that run against the results of a search.

To get what you define here, you'll  need to find or write a report that can drill down to the data you need.

[Aaron Butler]

Hi Nic, 

Thank you for your message. 

I did find a work around with filter count gadget in dashboard that did the job. 

Service Improvement = "Epic Link" in (NCSD-180, NCSD-9)

Unplanned Work = "Epic Link" = empty

Project Delivery = "Epic Link" not in (NCSD-180, NCSD-9)

AB