Automation email to list all open features and their blockers

[Julie moyaux]

I would like to create an automation email to list all open features and only list items that are linked to it via "blocks".

In other words, I want to list the stories, or other jira items, that are listed in the feature as "is blocked by".  (they are blocking the feature)

It would be great to be able to get the issue key, name, and status, but even just the key and name of the blocked items would be great.

I do not want to include other link types, such as mentions, etc.

Thanks.

[Craig Nodwell]

Hi @Julie moyaux welcome to the community.  Which version of Jira are you running?  If you are running Jira Data Center you could build out an automation rule that could perform this.  And as already suggested if you have scriptrunner you get expanded jql functions that will easily suite the above requirements that out of the box jira will not.

[Julie moyaux]

I don't know actually.

I have this setup (was for story, but I could easily change for feature), the problem is that it will show all of the links in the email, not just the blockage ones.

[Bizz]

Do you have scriptrunner installed on your instance?

[Julie moyaux]

I don't know how to know the answer to this.

[Bizz]

Go to Issues in your top header row -> Click Search for Issues -> Switch to Advanced Mode -> In the search box, start typing "issuefunction".. does your Jira recognize this syntax?

Scriptrunner gives additional functions to search in Jira, like linked issues which are of type "Blocker" or blocked etc.. So if you can verify above steps then we can give you a syntax for your problem statement..

[Julie moyaux]

Thank you so much! Yes it seems to know that.

[Bizz]

Great, now before we set up emails.. can you please clarify your requirement..

Do you want, for a given list of features, the list of stories which are blocked? Can you try below query in advanced mode and see if results look like what you expect?

issueFunction in issuesInEpics('project = ABCD') and issueFunction in hasLinks("is blocked by") and status != Done

replace ABCD with the project where you have features and,

if an issue's Terminal status is not "Done"...  for example, if you guys use "Completed" instead of Done.. replace that as well..

If this is not the result, please clarify what are you looking for in your email..

[Julie moyaux]

I'm looking to iterate through all jira items in the project and list all items still showing as blocking each item. Would be great to have them grouped together by each item.  For example, item 1 might have 2 blockers, item 2 might have 5, etc....  I would like to see the item being iterated (its key and summary as a link or whatever) and then show the items blocking it after it.  If it has to repeat the item each time that is ok.  Best would be to only show the item once and then all the blockers after it.  Would it be possible to also show the status of the item that is showing as blocking?

I don't want to see any other links of any other type other than blocking.

Once I have that I can probably break it down per epic and have a separate email for each epic or feature.

Thanks so much!