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

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


1 badge earned


Participate in fun challenges

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


Gift kudos to your peers

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


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!


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
Community Members
Community Events
Community Groups

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

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


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


2 answers


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,


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


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
AUG Leaders

Atlassian Community Events