Write JQL filter to search issue field

[Robert Indelicato]

Hi I am trying to create a JQL that can query issues under given epic where epic fixVersion and issue fixVersion do not match.  The query is to catch discrepancies where issues have been assigned to incorrect fixVersion.  

[Thomas Magny-Garcia · Accepted solution]

Hi @Robert Indelicato ,
I think your request is quite a good idea! But I don't think it is possible for every fixVersion. I mean you may be able to do that for a specific version, and you should change your query for each fixVersion. I tried a query using the latestReleasedVersion:

 issueFunction in issuesInEpics("fixVersion = latestReleasedVersion()") and fixVersion != latestReleasedVersion() ORDER BY Rank ASC

Hope it helps !

[Robert Indelicato]

I'm a step closer with it and it works as long as i replace "latestReleasedVersion() with actual fixVersion name like below (I think this is what you meant).  Is there a way to do this without explicitly stating the version name?

project = xyz AND issueFunction in issuesInEpics("fixVersion = 'abc'") AND fixVersion != "abc" AND Sprint in openSprints()

I tried:

project = xyz AND issueFunction in issuesInEpics("fixVersion = unreleasedVersions()") AND fixVersion != unreleasedVersions()

[Robert Indelicato]

I think I got it now

project = xyz AND issueFunction in issuesInEpics("fixVersion in unreleasedVersions()") AND fixVersion not in unreleasedVersions()