How can a JQL query be used to find ≠ values on a single issue?

Question

I am needing to create a query to identify when the Version Name and the associated Release date on a single issue are not equal.

Our previous process required users to enter the release date as the Version Name (dont ask...lol) and we are now transitioning to instead use the associated Release date field. Until we can ensure adherence to entering the Release date, we are asking users to put the same date in both fields. To monitor this process, we are currently needing to export the data and look for the mismatches in excel; however are hoping someone has a way to look for these mismatches directly in the query and can save us this additional step.

The question is can JQL be used to look for (Release date ≠ Version Name)

Kai Becker · Answer

Hi @alexander_dvorkin ,

out of the box, this is not possible via JQL. You can't compare values in a way SQL supports. But if you have Scriptrunner installed, there might be a solution: issueFieldMatch

It takes the following parameters:

* subquery
* fieldname
* regexp (for comaprison)

Usage: issueFunction in issueFieldMatch("project = JRA", "description", "ABC\d{4}")

Hope this helps. There is also SQL for Jira, which might be worth looking at.

Nir Haimov · Answer

Hi @alexander_dvorkin

Use this for version:

fixVersion not in (1.0.0, 1.1.0, 2.2.0)

And use this for dates:

fixVersion not in releaseDate("on 2020-12-31")

You can google for "jql release date" for more dates example