Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to set the title of a JQL report?

atsalolikhin July 24, 2020

Hello,

I've created several custom JQL reports.  

As a Jira user, I would like to see the report title when I look at the report instead of seeing the raw JQL query.

For example, if I wrote a JQL query to see all Pending issues in the Sysadmin project, I want the report title to be "Sysadmin - Pending".

In other words, I want a title, as in https://stackoverflow.com/questions/15625305/using-standard-sql-how-do-i-make-a-report-with-a-top-title

 

Like the \C option in PostgreSQL's psql utility:

 

\C [ title ]

Sets the title of any tables being printed as the result of a query or unset any such title. This command is equivalent to \pset title title. (The name of this command derives from “caption”, as it was previously only used to set the caption in an HTML table.)

 

I looked at the JQL documentation but didn't see anything like this.

 

2 answers

1 accepted

0 votes
Answer accepted
atsalolikhin July 24, 2020

I noticed clicking around I can save my custom report as a filter, and then the filter name shows up as a title.  So this effectively accomplishes what I wanted to solve as far as titling the report is concerned.  (Though it still shows the raw jql, which I want to hide.)

0 votes
Bill Sheboy
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 24, 2020

Hi @atsalolikhin  -- Welcome to the Atlassian Community!

How are you sending these reports?  For example, email, Slack post, etc.

Have you investigated the automation rule features?  You could build a report using your JQL, and trigger or schedule it to send the results with a bit more formatting than with a subscribed filter.  You can use basic HTML for the formatting.

Please see this documentation for more details:

https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/

 

Best regards,

Bill

atsalolikhin July 24, 2020

Thank you, Bill!  I am not sending these reports, I am viewing them through the Web UI.  

Bill Sheboy
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 24, 2020

Gotcha.  If you want something more configurable than out-of-the-box JIRA Cloud, you may need to investigate the marketplace for potential add-on features, or build an app using data from the REST API.

Best regards,

Bill

Like atsalolikhin likes this
atsalolikhin July 27, 2020

Got it, thank you very much, Bill!

 

Best,

Aleksey

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events