create JQL that compare date field between epic.Field.dateValue to his issue.sameField.dateValue

eli_puxcej

Hi,

I have a task to add a quick filter to an epics board that should present:
* only epics that the epic.fieldValue (date type) < issueInEpic.FieldValue (same field) - per epic
* only epics that the issueInEpic.FieldValue is Empty

I already implemented the seconed option - "issue type= epic and project = X and issueFunction in epicsOf ("Y is empty)"
I didn't find a way to implement the first option and i pretty sure there isn't a way to do it with the existing custom JQL. am i right?

It mean that my only option is to create a new custom JQL function? ( like the examples here: https://scriptrunner.adaptavist.com/4.3.3/jira/custom-jql-functions.html#_project_versions_example)

thanks!

Eli

Mauricio Karas

Hey, Eli. Thanks for reaching out to the Atlassian Community!

From what it looks, you're trying to compare two date fields in a JQL. And as you guessed, this is not possible in Jira, not without a plugin at least.

Check out this other Community question which describes a similar issue.

There is this feature request created to add this feature to the JQLs. The workaround is to use the ScriptRunner plugin which introduces a function to compare dates:

issueFunction in dateCompare("", "resolutionDate > dueDate")

Kind regards,
Maurício Karas