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; } } }

How do I filter tasks with changed status?

Evgeny Lepilov

I'm trying to get a list of tasks with a changed status. I am interested in tasks that have been completed (had Done status) and reopened again (new status - In Progress ) at some point in the past. These tasks can either be in the In progress status, or closed again. I am interested in their reopening moment, to calculate the percentage of reopened tasks.

Im using python-jira library

My filter query

jql = 'project=' + project_key + ' AND status changed FROM "Done" TO "In Progress" '

But the list is empty.

If I try get smt like

jql = 'project=' + project_key + ' AND status="Done"'

jql = 'project=' + project_key + ' AND status="In progress"'

it works.

Can you help me with this task?

Accepted answers

Andrej Freeze greenique

Hey @Evgeny Lepilov ,

to me this looks fine. Maybe it's due to "In Progress" being spelled differently both times.

Does your workflow contain a transition from Done to In Progress?

Cheers,

Andrej

All comments

Andrej Freeze greenique

Hey @Evgeny Lepilov ,

to me this looks fine. Maybe it's due to "In Progress" being spelled differently both times.

Does your workflow contain a transition from Done to In Progress?

Cheers,

Andrej

Evgeny Lepilov

Hey< @Andrej Freeze greenique Thanks for your ansver.

For testing I created new jira project with several tasks and changed the status of these tasks several times from :

To Do to In progress -> Done->In Progress->Done

Andrej Freeze greenique

Does your JQL query work if you use it within jira's issue navigator? Executing it there will likely make it easier to debug.

Maybe it is also due to the Space at the end of your first query.

But creating a query like project = EXMPL and status changed FROM "New" to "In Progress" works fine within our system.

Evgeny Lepilov

I removed space from the end of query, but didnt help.

Im new in jira api and didnt understand what you mean jira's issue navigator. How How can I use this?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

api

jira-cloud

python