How to filter for ticket added to fixversion after release date

[Mattia Gibilaro]

In release page I have 2 data field: 

1) Start Date 

2) Release Date

I want to filter ticket added to that fixversion after the "Start Date". 

Who can I do it with JQL filter? 

[Ralph Gerald Varon · Accepted solution]

I don't think that is possible with standard JQL because:

1. JQL does not support filtering based on FixVersion fields like Start Date or Release Date.
2. JQL only queries issue fields, and FixVersion metadata is stored separately.
3. There's no native way to track when an issue was added to a FixVersion in JQL.

But may I suggest a workaround for your automation.

Workaround: Using Jira Automation to Extract Dates

If you're looking to retrieve Start Date and Release Date dynamically and use them in an automation, you can do the following:

You can use a Send Web Request Block using the following:

• Method: GET
• Endpoint: {{baseUrl}}/rest/api/3/version/{{issue.fields.fixVersions.last.id}}
• Body: Empty
• ✅ "Delay execution of subsequent rule actions until we've received a response for this web request" check that.

Headers:

• Authorization: {{Email + API Key in Base64}}
  • Check this Guide →   Automation for Jira - Send web request using Jira ... - Atlassian Community
• Content-Type: application/json

Then use these smart values to get the Start Date and Release Date.

• Start Date: {{webhookResponse.body.startDate}}
• Release Date: {{webhookResponse.body.releaseDate}}

Hope it helps!

[Mattia Gibilaro]

As workaround I need to find a way to monitor that 7 days before the "release date" no other ticket will be added to the fixversion.

[Bill Sheboy]

Hi @Mattia Gibilaro -- Welcome to the Atlassian Community!

That is not possible with the build-in features of JQL.

As workarounds you could:

• investigate marketplace addons which add to JQL, or
• you could use the CHANGED operator and hardcode the Start Date in the JQL

Please see this documentation page to learn more about the CHANGED operator: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

Kind regards,
Bill