project = HSV AND updated = resolved

Question

Why that Operation doesn't work?

project = HSV AND updated >= resolved

I want to get a List where the Timestamp of updated is newer than the Timestamp of resolved. The case is, that sometimes a resolved Task get's an update, based on Jira is receiving a Mail with the Ticketnumber in the subject.

I get de Message: 
Datumswert 'resolved' für Feld 'updated' ist ungültig. Gültige Formate umfassen: 'jjjj/MM/tt HH:mm', 'jjjj-MM-tt HH:mm', 'jjjj/MM/tt', 'jjjj-MM-tt' oder ein Zeitraumformat wie '-5t', '4w 2t'.

Bill Sheboy · Accepted Answer

Hi mike.bruderer@tg.ch -- Welcome to the Atlassian Community!

Jira's JQL is not a SQL, and unfortunately cannot compare different issue fields in a query.

Some possible work-arounds may be guided by how frequently you need to perform such queries and willingness to purchase addons from the marketplace:

* need this infrequently* export the issues to a spreadsheet and perform the query in the other tool

* need this often, and do not want to purchase addons* investigate any free marketplace options which might help with such queries, or
* pull/push the issues into another tool for queries, or
* use an automation rule to detect/mark when this situation occurs (i.e., update after resolved) and then use JQL to report on that

* need this often, and willing to purchase addons* investigate the marketplace for JQL and/or reporting addons to support this type of query

Kind regards,
Bill