How can I filter issues that have Target end - Target start longer then X months?

Martin Dobrý May 5, 2022

How can I filter issues that take too long? Meaning say the time between target start and target end are say 6 months.

OUr JIr instance doe snot allow addons, need to use only core functionality

3 answers

1 accepted

0 votes
Answer accepted
Martin Dobrý May 9, 2022

Here is a solution that works:

issueFunction in dateCompare("project=XYZ", "Target end > Target start +6m")

0 votes
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 5, 2022

Hi @Martin Dobrý,

Welcome to Atlassian Community!

Without an app, your only option would be to use the REST API to accomplish this since JQL doesn't allow you to compare between dates. 

Martin Dobrý May 5, 2022

@Mikael Sandberg was a bit worried it would be like that, but thank you.

0 votes
Garrett McCreery
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 5, 2022

Hi Martin, welcome to the community.

I'm afraid what you are asking is not possible without a plug-in. 

Martin Dobrý May 5, 2022

Hi Garrett, 

pitty, but thanks for confirmation.

Suggest an answer

Log in or Sign up to answer