How can I write a JQL query to search for all tickets in a fix version that has not passed.

[Erin Sinnwell]

Right now I have:

project in (CORR, ALIP, AOE, DI, DSS, AGN, ASP, DP, ED) AND "Business Area" = "PIP/CCC" AND type not in (Task,Sub-task, Epic, "Portfolio Epic") and fixVersion in releaseDate()

but am not sure what to put for the releaseDate()

[Jehan Bhathena]

Hi @Erin Sinnwell 

I'll agree to what Bill mentioned, the releaseDate is a Scriptrunner function:

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/versions

You should be able to use it in the below fashion:

fixVersion in releaseDate("on 2016/09/07")

[Bill Sheboy]

Hi @Erin Sinnwell -- Welcome to the Atlassian Community!

That is not a built-in JQL function. 

I believe it may be one from the ScriptRunner app / addon, and so likely takes a date value in quotation marks.  Perhaps check their documentation to confirm.

Kind regards,
Bill

[Hannes Obweger - JXL for Jira]

Hi @Erin Sinnwell

to the best of my knowledge, this isn't possible in plain Jira/JQL.

This being said, you're open to solutions from the Atlassian Marketplace, you'll have options available. E.g., your use case should be easy to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the fix version release date.

This is how it looks in action:

As you can see above, you can easily sort and filter by your issues' fix version release date, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on them directly in JXL, trigger various operations in Jira, or export them for further processing.

Any questions just let me know,

Best,

Hannes