project = HSV AND updated >= resolved

[mike_bruderer_tg_ch]

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 solution]

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