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

Is it possible to make a JQL query that compares dates?

Antoine Goutagn

I would like to make a query that, in a specific project, returns issue that have been updated after the issue has been marked "resolved". I tried the following:

project = "Jira Support" and updated > resolved

But that returns an error: Date value 'resolved' for field 'updated' is invalid.

Is there any way to make that query?

Accepted answers

JamieA

There are workarounds, depending on how dirty you want to get your hands.

For example @Dieter made a suggestion to solve pretty much the same problem here: https://answers.atlassian.com/questions/37374/does-jira-provide-a-view-or-report-that-show-issue-history-changes-for-multiple-issues?page=1#37948, or you could write your own JQL function plugin to do it.

All comments

Dieter

Looks like this is still an open issue : https://jira.atlassian.com/browse/JRA-20727

JamieA

There are workarounds, depending on how dirty you want to get your hands.

Dieter

Dear heaven, i forget my own answers

Dieter

So what Jamie suggests is to implement a scripted custom field that returns 1 if Updated > resolved and then search for all issues with value = 1

JamieA

That's what I'm suggesting Dieter would suggest if he remembered his answers ;-)

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql