How to use jql for missing Baseline end date calculations

Hi @jivan_patil 

JQL can't compare two fields to each other — the right-hand side of a clause has to be a literal value or a function, so resolutiondate > "Baseline End Date" treats the field name as text. That's a JQL limitation, not a syntax issue.

The usual workaround is to have Automation record the result in a field you can query:

1. Create a marker field (a label like missed-baseline, or a checkbox / number field).
2. Automation rule —
   Trigger: Issue transitioned to Done (or Field value changed: Resolution).
   Condition: Advanced compare — {{issue.resolutiondate.diff(issue.Baseline End Date).days}} greater than 0.
   Action: Edit issue → add the label / set the field.
3. For issues already resolved, run a one-off scheduled/manual rule with the same condition over statusCategory = Done AND "Baseline End Date" is not EMPTY to backfill.

Then your count is simply labels = missed-baseline (or whatever field you chose).

If you don't want to add fields, the other option is a JQL-extension app — several on the Marketplace support field-to-field comparisons in search.

Hi @jivan_patil 

You can use ScriptGenie (full disclosure: I am the developer) to define custom JQL functions. See example below: