Comparison of field

[Vandana Mandal]

Hi 

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?

[Walter Buggenhout]

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!  

[Charlotte Santos -Appfire-]

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!