Get time spent in linked tickets by group of user

[Chirag]

Hello everyone,

I am stuck with a scenario. Please look into it below :

Scenario :

• Task A : TA-01 is linked to 2 other tasks
  • Task B : TA-02
  • Task C : TA-03

There are 2 users belonging to 2 different groups:

• User_A 
  • Group : Developer
• User_B
  • Group : QA

Time log history against each task:

• Task A
  
  • 6May2023 : User_B : 4H
• Task B
  • 1May2023 : User_A : 2H
  • 2May2023 : User_A : 1H
• Task C
  • 4May2023 : User_A : 5H
  • 5May2023 : User_B : 7H

As per the scenario above I am trying to figure out an automation on jira that when run on Task A on 7May2023 would would update 2 fields with following data :

1. Total time logged by group 'QA' users in all linked tickets. Output should be 7H. This includes :
   1. Task C
      • 4May2023 : User_A : 5H
2. Total time logged by group 'Developer' users in all linked tickets. Output should be 8H. This includes:
   1. Task B
      • 1May2023 : User_A : 2H
      • 2May2023 : User_A : 1H
   2. Task C
      • 4May2023 : User_A : 5H

Looking forward to any help.

Thank you,

Chirag.