nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Ralph Gerald Varon_0fe7fj

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

JQL does not support filtering based on FixVersion fields like Start Date or Release Date.
JQL only queries issue fields, and FixVersion metadata is stored separately.
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}}

Screenshot 2025-02-17 200317.png

Screenshot 2025-02-17 200442.png

Screenshot 2025-02-17 200533.png

Hope it helps!

All comments

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

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.

Ralph Gerald Varon_0fe7fj

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

JQL does not support filtering based on FixVersion fields like Start Date or Release Date.
JQL only queries issue fields, and FixVersion metadata is stored separately.
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}}

Screenshot 2025-02-17 200317.png

Screenshot 2025-02-17 200442.png

Screenshot 2025-02-17 200533.png

Hope it helps!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

query