Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

eli
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 25, 2018

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

1 answer

0 votes
Mauricio Karas
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 7, 2018

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

Suggest an answer

Log in or Sign up to answer