Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,366,187
Community Members
 
Community Events
168
Community Groups

How to create a subscription to a Report or Filter?

My JIRA Admin provided me a filter (JQL Query) for all the stories/bugs related to my project.  End of each business day I run this JQL query and export the data and identify if there are new issues or any stories/bug were removed from my object.  I would like to automate this project.

I would like an email notification at the end of the day indicating all the new stories/bugs that were assigned to my project (i.e if the JQL fetches any new records, I should get an email at the end of the day) 

Is this done through subscription?  Or is there any other way to automate this email notification?  In the JIRA Screen, Under Tools-> I do see only 'Clear Sorts'.  Do I need special permissions to create subscriptions to filter?

Thank you

4 answers

13 votes
srikanth u Community Leader Jul 18, 2018

Yes, you can.

Please use the below query to get the details at the EoD.

1) Create a Query:

project = XXX AND issuetype in (Story,Bug) AND created >= -24h

2). Save this filter Query.

3). Go to Details and click on New Subscription

4). Now select the Schedule Daily and set the Interval as per your needs.

 

Enjoy :)

is there any way this subscribed report send JIRA Results in Excel as attachment.

Like # people like this

Have you got the answer for same? I am also looking for the same.

Like # people like this

I need to have the subscription go to multiple users. How do I do this?

Like Vikramjit Singh likes this

Create a Jira user group and add those users you want to send emails to.

In the New Subscription setup, choose that Jira user group instead of 'Personal Subscription' 

@Oleg Romanov  Sorry, I'm not able to see the option of Jira user group instead of 'Personal Subscription'. Is it possible to share the snapshot or link here. FYI.,. I'm using the cloud version of the JIRA and admin right as well. 

0 votes
John Funk Community Leader Aug 19, 2022

Hi @Raju Kris  - Did you ever get this solved?

I got this, but need to have the subscription go to multiple users. How do I do this?

I believe you would need to have the subscription send to a group with the people you want it to go to. If you aren't an administrator, you will need to work with one to set that up.

-Jaron

Hi Jaron 

 

Do you have solution for my question? How can I send the attached xlsx or CSV of subscription?

I'm not sure I understand your question. You're looking to send a file representation of a filter on some kind of schedule?

I don't think this functionality is available out of the box, the subscription functionality just sends a formatted list via email, but you can export the results of a JQL query to a CSV file manually and send that.

Or, if you have API access, you could use /search (https://docs.atlassian.com/software/jira/docs/api/REST/latest/#api/2/search) to retrieve all the issues for a particular JQL query, format the data however you like, and send it out.

That depends on the way how your admin provided you with the JQL query. If he shared a saved filter with you he is the owner of this filter and needs to set up a email subscription on your behalf.

If he shared the JQL query only per email you can save that as a personal filter and define a subscription to that filter according to your needs: Receiving Search Results via Email

Hope that answers your question!

 

How does the owner of the JQL query can setup an email subscription on behalf of somebody else? It seems that the subscription can only be assigned to groups not individuals, is this correct?

Thank you,

Roberta

For sending the subscription to someone else, you've to create user groups in Jira first(Need admin rights). 
Then select the group under the recipient's list for the subscription. 

Like Julie Sagar likes this

@Sandeep Nair  I have created the group to whom I want to send this email on daily basis.But, I'm not able to see the options of adding the recipient's group in this list for the subscription. Kindly share the link or snapshot. 

srikanth u Community Leader Sep 27, 2021

@Vikramjit Singh Currently Jira not supporting filter subscription on the group level.

The way I do is get the notifications to my email box (Outlook/Gmail) and autoforward the same based on the Rule set in Outlook/Gmail.

 

I hope this will resolve the issue.

Thanks!

Srikanth.

Suggest an answer

Log in or Sign up to answer