JQL Query for Issue transition history

Gnanabaskar
Contributor
July 22, 2022

Hi,

I need suggestions on JQL query based on Issue transition history.

Example: Dev Complete ( Workflow Status )

I want to know the list of tickets that transitioned through this status at any point of time.. Is there a way to achieve this via JQL query ? 

 

Thanks,

Baskar

3 answers

1 accepted

0 votes
Answer accepted
Rafael Costa
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.
July 22, 2022

You could use the WAS, and DURING operators to it. Ex:

project = TEST and status was in ("In Progress") DURING ("2022/07/20", "2022/07/21")

this query returns the issues from project TEST that was In progress between 20/07/2022 to 21/07/2022.

Gnanabaskar
Contributor
July 22, 2022

Thanks @Rafael Costa  That works..

Like Rafael Costa likes this
1 vote
Yuliia_Borivets__SaaSJet_
Atlassian Partner
July 22, 2022
Petru Simion _Simitech Ltd__
Atlassian Partner
November 3, 2024

Thanks you. I will read and comply.

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
November 3, 2024

You can also use CIFJ - Issue History Dashboard app.

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

You will be able to filter your search and also export the data in CSV format without the need to process the JQL call result yourself.

Yuliia_Borivets__SaaSJet_
Atlassian Partner
November 3, 2024

Hi @Petru Simion _Simitech Ltd__ 

"As a general guideline, we ask all members to avoid replying to content older than six months. A good practice is to always check the date before responding."

Please read and follow the Community rules here:
https://community.atlassian.com/t5/App-Central-articles/Atlassian-Community-online-guidelines-Marketplace-Solution/ba-p/689723

Suggest an answer

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

Atlassian Community Events