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

[Antoine Goutagny]

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?

[JamieA · Accepted solution]

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.

[Dieter]

Dear heaven, i forget my own answers ;)

[Dieter]

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

[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 ;-)