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

Get a search result for "status changed" between now and x days

Al Ba

Hi all,

please help me to clarify my approach. I want as a result only Ticket #2, the ticket which status was changed between (now) and the last 15 days.

Example

Ticket #1: date of last status change 1st of October

Ticket #2: date of last status change 1st of November

Search is executed on 10th of November

Search query

project = abc AND status = xyz AND NOT status changed during (-15d, now())

Expected result

Ticket #2

Actual result

Ticket #1 + #2

Accepted answers

Tom Lister_fo1j4e

Hi @Al Ba

I would use clause

status changed AFTER startOfDay(-15d)

to look into last 15 days

All comments

Alexey Matveev

Hello,

I just tried the same JQL query on my Jira Cloud instance and it works as expected.

Tom Lister_fo1j4e

Hi @Al Ba

I would use clause

status changed AFTER startOfDay(-15d)

to look into last 15 days

Al Ba

Many thanks but it still does not work for me.

I should mention that I have moved most of the tickets from another project to the current project (without that the status had changed). Could the move have impact on the search results?

Tom Lister_fo1j4e

Hi Alex

open an issue and look at the history or activity tabs to see if a status has changed.

I would assume moving from one project to another has set the matching status in the target project.

Al Ba

I had matched the status of both projects before, therefore was no status change by moving the issues.

I will check the query in another project to understand if this is the reason for my results.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

status