Jira automation: Add all the "Is tested by" linked tests to a test plan

[Elizabeth Thomas]

Hi!

I'd like to set up an automation that does the following. 

When the sprint starts, create an issue with the type "Test Plan". Then for each ticket in sprint that has a "tested by" link and test, add that test to the test plan that was just created. 

I'm stuck on the order of how to set the automation flow, and how to get jira to go through each ticket in sprint and grab the test that's under the "tested by" link. 

Thank you for any help provided!

[Bill Sheboy]

Hi @Elizabeth Thomas 

To do what you ask, I believe your rule would need to gather the issues in the sprint using JQL with a Lookup Issues action, and then use both smart value, list filtering to find the ones to link to the Test Plan.

If I understand your structure (not the hierarchy), it is like this:

• a Sprint containing
  • issue A
    • linked with "tested by" to
      • issue 1 (which is a Test issue type)
  • issue B (has no linked test)
  • issue C
    • linked with "tested by" to
      • issue 2 (which is a Test issue type)
  • issue D (has no linked test)

And so you expect some issues in the sprint to not have linked Test issues, correct?

Assuming the trigger is Sprint Started, the lookup JQL could be the following, which is then used with list iteration and filtering to get the Test issues for connection to your Test Plan issue.

project = yourProjectName AND sprint = {{sprint.id}} AND issueLinkType = "Is tested by"

Please adjust this based on the specifics for your links and project, and then try testing it stand-alone first before use in your rule.

Kind regards,
Bill