Get time spent in linked tickets by group of user

Chirag May 9, 2023

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.

 

1 answer

0 votes
Ken McClean
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 9, 2023

This feels like it would be pushing the limits of what automation is capable of.  Do you have ScriptRunner?  You might need to create some custom reporting.

Chirag May 11, 2023

Thank you for the response !

 

Sorry we don't have any ScriptRunner apps on our instance. Is there any other possible solution to this ?

 

Thank you,

Chirag.

Ken McClean
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 11, 2023

I mean, you could do it externally with a Python script, but that's getting pretty complicated.  I'm sure there are other extensions out there that would do it, but I'm not aware of them.  Sorry!

Chirag May 11, 2023

Ok thank you. I will keep looking.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events