Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,553,430
Community Members
 
Community Events
184
Community Groups

Query to retrieve the number of times a task (or subtask) has been set to a certain status value

Boris LINDAUER
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 26, 2023

Hello

For an epic, I would like to have the list of tasks / sub tasks who have changed to a status "TEST KO" over the duration of the project.

For example, it would return something like that

Task 1 , 05/01/2023
Task 1 , 05/04/2023
Task 1 , 05/12/2023
Task 1 , 05/25/2023
Task 2 , 05/03/2023
Task 2 , 05/27/2023
meaning that the task 1 has changed 4 times to "TEST KO", Task 2 has changed twice on those specific dates

OR something like

Task 1 , 4
Task 2 , 2
which would mean that the task 1 has been set 4 times to "TEST KO", and Task 2 twice

Thanks

2 answers

Hi @Boris LINDAUER 

if the epic link field is present in the activity and sub activity the query is this:

issuetype in (Task, Sub-task) and "Epic Link" in ("name epic")and (status changed to "TEST KO"  and status= "TEST KO")

You must insert  in " name epic"  the name of the epic.

if there is script runner  and epic link is not present on task, the possibile  query is:

issueFunction in linkedIssuesOfRecursive("issue = issueKeyEpic") and (status changed to "TEST KO" and status= "TEST KO")

I hope I have been helpful.

Kinds Regards,

Laura

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 26, 2023

Hi,

Welcome to the community

You can achieve this using the REST API and look at the history or look in the marketplace to find a plugin

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events