Comparison of field

Vandana Mandal April 1, 2024


currently i am working on the dashboard . I want to compare the fields : for projecting delayed vs planned. 
two fields are - Expected release date and Forecast release date. 
is there any JQL which jira supports?

2 answers

1 vote
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 1, 2024

Hi @Vandana Mandal,

JQL is a search feature. It lets you search for a list of issues that you can then display in a dashboard gadget, but it has no native support to compare fields.

You may need to look into a marketplace app to add this compare function or look into automation to help you mark overdue issues in a custom field for that purpose. You may have a look at this related thread.

Hope this helps!  

0 votes
Charlotte Santos -Appfire-
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.
April 1, 2024

Hi @Vandana Mandal 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to compare these date fields:

issue in dateCompare("'Expected release date' < 'Forecast release date'")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events