How to use jql for missing Baseline end date calculations

[jivan_patil]

Want to know the JQL statement which can provide the result as the no. of ticket has missed the baseline end date, based on the Baseline End date & Resolution date.

I tried with the below statement but it's not giving results due to limitation of clause.

statusCategory = Done

AND resolutiondate > "Baseline End Date"

kindly suggest the appropriate syntax for above. Thanks.

[Habib K - Plugio]

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.

[Geert __ 2improveIT]

Hi @jivan_patil 

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