nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Query for Issue transition history

Gnanabaskar

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

Accepted answers

Rafael Costa_o9pc4y

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.

All comments

Rafael Costa_o9pc4y

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

Thanks @Rafael Costa That works..

Yuliia_Borivets__SaaSJet_

Hi @Gnanabaskar

Here is the article that can be handy for history searches:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/History-searches-with-amp-without-JQL-10-examples/ba-p/2017596

Petru Simion [Simitech Ltd.]

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_

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

Petru Simion [Simitech Ltd.]

Thanks you. I will read and comply.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud