Is there a way to create a JQL filter that compares 2 date fields, e.g. Duedate < Resolved

[Tony Giovenali]

I am trying to filter for Bugs that were Resolved (marked as Done) after their Due Date. Is there a JQL query for this 

project = "myproject" AND issuetype = bug AND status = Done AND duedate < resolved ORDER BY issuekey ASC

[Alex Koxaras _Relational_]

Hi @Tony Giovenali and welcome to the community,

Unfortunately, you can't compare fields within the JQL.

What you can do, outside the box, is to use a JQL from an automation rule and compare the date field you want to another's date field smart value. E.g.:

project = "myproject" AND issuetype = bug AND status = Done AND duedate < {{issue.fields.resolved}}

The above can be accomplished, but as I mentioned only within an automation rule.