Subscription to a structure view
Jira has a "issue filter subscription" feature, which runs a filter at a certain time of the day and email the user with the results. Structure could have a similar subscription feature tied to a particular structure's view, where a snapshot of that view would be taken at a certain time of the email and the results would be exported to excel and emailed to the user.
My company currently use structure to keep track of our day-to-day progress by manually exporting structures to excel at the same time each day. Automating the exporting would allow us to automate the remaining of the pipeline and remove any room for human error.
Ideally, when subscribing to a structure you would be able to not only choose a view (which determines the fields to be exported) but also any filters or transformations that are applied to that structure. So the act of subscribing would take a snapshot of all those settings, and then an "export to excel" would be run at a recurrent schedule and emailed to the user.
collecting requirements (see comments)
-
Zhen commented
Hi Igor,
I am also looking to do the same thing. Can you give an example of the exporting address format? I also ideally want the structure to be in the body of the email as well, do you have any suggestions on how to achieve that? I currently have ScriptRunner.
Thanks!
Zhen -
Hi Tiago,
No problem - thanks for coming back to this topic. Let's keep it in mind. For now, it's possible to have this achieved through an external script, or probably through a scheduled Jira task with Script Runner. We might have additional means in the future as we introduce more automation capabilities.
Igor
-
Tiago Fernandes commented
Igor, I apologize for missing your comment. External automation is definitely a way to go about it, I don't currently have the means to run it but it's worth looking into it.
-
Tiago, thanks for your suggestion! It does make sense, although I'm not sure how popular such requirement would be. I'll record it as a feature.
I think the way to address this right now is through external automation: one can write a script that would call the Excel exporting address, pass the parameters and download the resulting file, then send it as an attachment. Would you have a separate host to run such script regularly?