Automation rule for version

Question

Hi

I have a use case where I want to get weekly email or notification for all the pending releases in the projects that I am managing. Is there a way to schedule an automation rule to run once a week that would get me the summary?

eg I have project A with pending release 1 and release 2, Project B with pending release 3 and Project C with pending release 4 and 5.

I want to set up an automation rule to send an email to me on a weekly bases on the status so I can get a snap shot of all my releases.

Bill Sheboy · Answer

Short version is that you cannot do exactly what you want with out-of-the-box JIRA.

JIRA's JQL is not SQL.  It is unlikely that Atlassian will make it so; there are marketplace vendors who have products to fill the gaps in JIRA and JQL.

If you want to investigate additional query add-ons, they do appear to have GROUP BY clause support.  Without add-ons, you can use rules to watch the versions and subscribed JQL queries to get issue updates.

Another approach might be to use the REST API functions to pull the data and versions from JIRA.  You can probably get most of what you want from there, but you will need to parse the resulting JSON to get the data.

rmethaji · Answer

Thanks a lot Bill

This helps me a lot in getting the query close to what I want but the problem I have is that he query still returns list list of issues. I want to get the list of versions. Is there a way I can run group by for the query so I get a list of all the versions and then get the release dates for those versions. This way I can send an email to the mangers with a list of pending releases and their release dates.

Right now since the schedule queries are returning issues and not versions. I am not able to do it. So I guess what I need is a group by funciton or a way to query versions in jql instead of issues.

Bill Sheboy · Answer

Hi @rmethaji

Thanks for clarifying.  The issues you note is why I suggested creating a query and subscribing to it.  For example:

project IN (MyProjectA, MyProjectB) AND fixVersion IN unReleasedVersions() ORDER BY Key

Please see this documentation for more information on advanced searching functions, such as unReleasedVersions()

https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html