nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filtering issues where "due date" > "target end"

Giampiero Vincenti

Hi, I would like to filter issues where "due date" is higher than "target end" in order to see which issues have been completed later than planned initially.

I already have included in my projects both columns.

Can you explain me how to do it please?

Thanks

Accepted answers

Jack Brickey

JQL does not allow for date compare. You will need an addon app, e.g. Scriptrunner

Kristian Walker _Adaptavist_

Hi Giampiero,

I can confirm with ScriptRunner for Jira Cloud you can use the Date Compare enhanced search function which is documented here and this page provides examples of how this function works.

Alternatively when on the Enhanced Search page you can click the + button at the end of the search bar to bring up a dilog that will give you a form that you can complete to define the query that you require.

Finally, I can confirm once the filter has been created you can save this filter and share it to reference in items such as Agile boards and the knowledge base article located here explains how to do this.

I hope this information helps.

Regards,

Kristian

All comments

Jack Brickey

JQL does not allow for date compare. You will need an addon app, e.g. Scriptrunner

Giampiero Vincenti

Thanks for the information @Jack Brickey . Do you know how to prepare this specific quick filter with ScriptRunner Enhanced Search?

Jack Brickey

I don’t. I have not used Scriptrunner for many years. However there are posts in the community on this so a bit of searching should produce results.

Kristian Walker _Adaptavist_

Hi Giampiero,

I can confirm with ScriptRunner for Jira Cloud you can use the Date Compare enhanced search function which is documented here and this page provides examples of how this function works.

I hope this information helps.

Regards,

Kristian

Giampiero Vincenti

Thanks Kristian! This information helped a lot. Best

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud