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 filtering for 2 status options

Bruce Williams_kbhj7x

What's wrong with this JQL?

project = SIR AND status changed from "In Review" to "In Progress" during ("2024-07-01", "2024-08-01")

I got the following off a quick search, it works, but why wont the above work?

project = SIR AND status changed from "In Progress" to "Closed" during ("2024-07-01", "2024-08-01")

TIA,

Accepted answers

Lisa Forstberg_o85gu4

Hi!

So the first JQL does not work but the second does not work?

What happens when you run the second one? Do you get an error or just no results? Can you post a screenshot?

Create a test ticket and move it through the workflow to status Closed to provide a test case to validate your JQL.

best regards

/Lisa

Laurie Sciutti

Hi @Bruce Williams and welcome to the Community! Can you confirm that your workflow actually has a transition from "In Review" to "In Progress"?

All comments

Lisa Forstberg_o85gu4

Hi!

So the first JQL does not work but the second does not work?

What happens when you run the second one? Do you get an error or just no results? Can you post a screenshot?

Create a test ticket and move it through the workflow to status Closed to provide a test case to validate your JQL.

best regards

/Lisa

Bruce Williams_kbhj7x

I can't seem to reply, I;ll try again

Bruce Williams_kbhj7x

The first on failed, the second one (copied from Google, worked). I tried the first again without "during" and the dates, and it works. What's wrong with the dates' statement I wonder?

Lisa Forstberg_o85gu4

What is your hosting type ? Cloud / on Prem (DC or Server?)

If you remove DURING("2024-07-01", "2024-08-01") you will get any ticket in the project that has moved from one status to the other status at any point in time. If you want only those that changed from 1st of july to 1st of august you add the during statement.

Try to type your way through the JQL instead of copying it in if you get a mixed result, just to avoid the problem with characters / spaces etc

Laurie Sciutti

Hi @Bruce Williams and welcome to the Community! Can you confirm that your workflow actually has a transition from "In Review" to "In Progress"?

Bruce Williams_kbhj7x

Hi Laurie, Yes, it has that direct step.

Bruce Williams_kbhj7x

Today the filter worked, I'm not sure what changed:

project = SIR AND status changed from "In Review" to "In Progress" during ("2024-07-01", "2024-08-01")

Welcome!

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

Quick Links

Find more posts tagged with

jira

unknown-hosting-type

jira-unknown-hosting-type