How to loop through the lookup results and link each issue to some other, per criteria

Inna S

Hi, 

we are doing a migration of the large data set and need to link some issues. 

Unfortunately the trigger 'issue created' used to link every newly created issue to an existing one matching a criteria, hit the throttling limit and can't be used.

I was thinking of making a different automation, that would

- look up all the issues matching a criteria (e.g. no link of specific type is present or a field is empty)

- for every issue in the lookup result, create a link between the 'current' issue in the loop and the one with the one field value matching field value in the 'current' issue.

 

I'm having trouble iterating over the lookup results: added Log step to print the issue key but this doe not work as expected.

I then can't seem to find the way to link two issues when one of them is 

- not the trigger issue

- not a recently created issue

 

Is there a way to link just two arbitrary issues or full the system into treating the lookup result as a triggerIssue of a kind?

Thank you!

 

Trudy P Claspill

Hello @Inna S 

You can use a smart value as the issue to which to link, per the help text in that action

How are you going to trigger the rule?

How many issues do you expect to be retrieved in your when you look up issues?

There are a few ways you can get a list of issues to operate on.

1. You could use a Schedule trigger and put a JQL into the trigger. The actions in the rest of the rule will be performed against each issue returned by the trigger. I'm not sure what the limit is on the number of issues a Schedule trigger JQL can return. And you don't actually have to make use of the Schedule. As soon as you create the rule you can manually trigger it with the Run Now button rather than having it run on an actual schedule.

 

2. The Lookup Issue Action. Note that action is limited to retrieving 100 issues. You can iterate through the results set using an Advanced Branch option:

 

3. For Branch > Related Issues > JQL is another option for retrieving a set of issues. Within the branch you would then be operating against each issue retrieved by the JQL.

 

As to getting the issue that you want to link to, I would need more details about how you would retrieve that issue by JQL relative to the current issue against which you are operating.