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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.