Search Text and date

Venkata P Pottam

We got field FixVersion with data something like 2023.07.13.

I need to build query to extract all the Jira issues which has the fixVersion which is within 15 days from today.

Jira Gurus over there, please help, if this is achievable.

 

We are on Jira v8.20.18 (Data Center/Server).

Piyush Singh_6prztl

To build a query that extracts all Jira issues with the FixVersion within 15 days from today, you can use the following JQL query:

project = YourProject AND fixVersion >= startOfDay() AND fixVersion <= endOfDay("+15d")

Here's an explanation of the query:

• Replace "YourProject" with the name or identifier of your specific project.
• The query uses the fixVersion field to filter the issues.
• The '>= startOfDay()' part ensures that the fixVersion is greater than or equal to the start of the current day.
• The '<= endOfDay("+15d")' part ensures that the fixVersion is less than or equal to the end of the day 15 days from today.
  
  By using this JQL query, you will be able to extract all Jira issues where the FixVersion falls within the next 15 days from today.