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; } } }

How to search for Epics having comparing values in two fields: "Target end" > duedate?

Aquarius

Dear experts,

I need to filter for epics in a certain project who's "Target End" is bigger than a "Duedate" - both are fieds.

When I try to do so, and type in: AND "Target End" > ...

Jira offers me to enter function, like "endofweek()", etc. but not field values.

How can I do that?

Accepted answers

Vikrant Yadav

Hi @Aquarius Unfortunately it's not feasible to create two date field value using Jira inbuilt functionality.

With the help of Scriptrunner for Jira plugin you can do enhanced search.

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/date#dateCompare

Thanks

All comments

Vikrant Yadav

Hi @Aquarius Unfortunately it's not feasible to create two date field value using Jira inbuilt functionality.

With the help of Scriptrunner for Jira plugin you can do enhanced search.

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/date#dateCompare

Thanks

Aquarius

Hi Vikrant, many thank for the answer, I have scriptrunner.

When trying to use it for "Target End" field getting an error, but it works OK for "resolutiondate":

WORKS OK: issueFunction in dateCompare("", "resolutiondate > dueDate")

ERROR: issueFunction in dateCompare("", "Target End > dueDate")

Can you tell me what is the issue?

Aquarius

Hi @Vikrant Yadav , many thank for the answer, I have scriptrunner.

When trying to use it for "Target End" field getting an error, but it works OK for "resolutiondate":

WORKS OK: issueFunction in dateCompare("", "resolutiondate > dueDate")

ERROR: issueFunction in dateCompare("", "Target End > dueDate")

Can you tell me what is the issue?

Vikrant Yadav

Hi @Aquarius I think this "Target End" field is an Advanced roadmap field, right ?

Is "Target End" searchable without issuefunction?
"Target end" is not EMPTY

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-data-center

data-center