It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create custom reports in JIRA

hi Team,

 

I am aware that there is automated report for Jira that can be scheduled by creating subscription, but I need custom columns in that. LIke Created and updated date in Jira can give me one more column open days for the ticket. Is it possible. Please help on this.

1 answer

Hi Ruchi

You can customize the columns of your filter to specify what kind of info you want to receive by subscription. Open your filter, click the Cog icon and pick Configure Columns. Then pick the Columns you want to display and set them in the desired order. Thos settings will be saved together with the filter.

Hey Daniel,

Thanks for responding back.

I think i did not frame my question correctly, My bad.

I can select the column which I want but what I can not do is manipulation of those columns.

Example, I can see there is a column "Created Date" but based on this I need to add another column which should be "Open for # of Days".

 

Also I am not able to get the report in proper format in the email.

Please also suggest me in getting proper HTML format report.

 

 

Thanks and Regards,

Ruchi

Hi Ruchi

The column you can add has to be a valid field for your Jira project. Do you have field "Open for # of Days" in your Jira project? Jira out of box does not support such a field, you can add a custom field and then using "script runner" to specify the behavior of it, for example, number of days the issue has been opened.

Alternatively, if you were just concern about issues that opened beyond X number of days, a simpler method is to use a JQL like "created < endOfDay(-X) ", which returns the issue created before X days from today.

 I am not quite familiar with Subscription format either, but I found this one, hope it help:  https://community.atlassian.com/t5/Jira-questions/Customise-JIRA-Subscription-Format/qaq-p/423794

"The column you can add has to be a valid field for your Jira project. Do you have field "Open for # of Days" in your Jira project? " - Can I create a column in my project?

Hi Ruchi

I guess you were asking how to add a custom field into your project? 

Yes, but you do need to have Jira Admin permission.

Please refer to https://confluence.atlassian.com/adminjiraserver/adding-a-custom-field-938847222.html

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Advanced Roadmaps

3 short videos to help you get started with Advanced Roadmaps

Hi community, I’m Roi, a product manager working on Advanced Roadmaps for Jira. While Advanced Roadmaps is a powerful tool to plan and track work at scale, we know it can be challenging to get star...

3,676 views 23 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you