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?

[Vikrant Yadav · Accepted solution]

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

[Vikrant Yadav]

I have Scriptrunner for Jira Cloud and it's working fine for me.