Automation - apply condition on linked issue

[Valerie Blondel]

Hi there !

Automation/JQL beginner here, but willing to learn :-)

Here is my case.  We want to improve the way we manage our trainings and competencies in my company.

We have 2 operating sites : Liège and Saintes.

For each competency, I have an issue in which I would like to sum up the hours of trainings followed on each site + as a group (Saintes+Liège).

The training hours info and the site info do appear in custom fields in the linked Formation issues.

Here is what I did so far :

Competency issue :

- Set up of custom fields to recup the training hours spent in trainings as a group, in Liège and in Saintes.

Formation issue : 

- set up of custom fields showing the site and the hours of training.

Automations :

- Groupe sum : working :-)

- Liège sum : not working.  It gives me the group total, even with condition Site = Liège.

I tried numerous ways to apply this filter, with conditions, with JQL... but none of them seem to work.  What do I do wrong ?

Thanks so much !

[Trudy Claspill · Accepted solution]

Hello @Valerie Blondel 

I am going to try to echo back to you what I believe you have described as the problem

Issue MRH-22 has multiple other issues linked to it with the causes/is caused by  relationship including 

• MRH-26
• MRH-28
• MRH-35

You want to total the hours for all of these linked issues int one field - GROUPE.

Some of those linked issues have a field - Site - set to "Liege". You want to total the hours for just the linked issues that have "Liege" in the Site field, and store that value in the LIEGE field of MRH-22. 

The problem is that the value you are ending up with in the LIEGE field of MRH-22 is the total of hours of all the linked tasks, not just the ones where the Site field is set to "Liege".

If I have stated that correctly, then you need to change this part of your Rule:

The JQL you are using there is selecting ALL the linked issues. If you want to choose only the linked issues where the Site field is set to "Liege" then you need to add this to the query:

AND Site="Liege"

That will reduce the returned issues to only the linked issues where Site is set to "Liege" and should then give you the total hours for only those issues.

[Valerie Blondel]

Yay, working, thanks Trudy :-)