You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I could use some advice on the following matter:
We have a Jira Cloud project "ABC" and a Jira Product Discovery project "DISC". We want to receive an e-mail every week with a list of Epics that meet the following conditions:
The idea here is that we get a list containing all Epics of the XYZ component with label "discovery" from the ABC project without a link to the DISC project.
Right now, in the "When" component, we query:
type = epic AND project = ABC and component = XYZ and label = "discovery"
Then we use the "If: Linked issues match" condition like this to find the linked issues in the DISC project: (and here I think we made a mistake, but I can't figure out what)
The main question here is simply: is it possible to automate our request, without any usage of for example Scriptrunner or external plug-ins?
As a side question: if possible, how can I make the "Then: Send email" send me only 1 mail with a list, rather than a separate email for each Epic found.
Thanks for helping out.
Hi @Mart Postma
First thing, this will be much easier if you have one of the marketplace addons to enhance JQL features. As you prefer not to do this, some possible work-arounds are...
(A) You could export all of the epics to a spreadsheet weekly, filtering out the ones missing the links of interest, either your types or the Polaris Issue Link that Jira Product Discovery (JPD) uses
(B) You could build something outside of Jira, which uses the REST API functions to get issues and perform the joins / queries more easily than inside of Jira
(C) A complicated automation rule (although I have not tried this approach) using either Lookup Issues or a Send Web Request to...
(D) Simpler automation rule, which is triggered in any project with epics, when an epic is linked to an issue. Add an indicator (e.g., label, custom field, etc.) to indicate the epic is linked to a JPD idea, and to remove it when the link is removed. That custom field (or label) could then easily be searched with JQL to find the epics, and used in a filter subscription to send the email.
Hi Bill, thank you very much for the elaborate answer.
I think I will try them all and see what works best for us. Regarding to my last question, do you have any suggestion on how to solve that issue? Or is it only possible to get 1 e-mail if you subscribe to a filter, rather than using automation?
Options (A), (B), and (D) allow you to manage how to communicate the results.
For option (C)...As you are using Jira Cloud, the Lookup Issues action of automation rules will allow you to both gather the issues as a group and to send one email, listing them. Please look here to learn more about that action: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues