Can we pull the data or can we write the filter for below Requirement * JIRA Project : ABC& XYZ * Ticket Types : Change Request, Defect, Story * Release Date : 7/1/2022 to 6/30/2022

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; } } }

Need an advanced JQL filter for below requirement

Sudharsan_pjc749

Can we pull the data or can we write the filter for below Requirement

JIRA Project : ABC& XYZ
Ticket Types : Change Request, Defect, Story
Release Date : 7/1/2022 to 6/30/2022

Accepted answers

Charlotte Santos -Appfire-

Hi @Sudharsan

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

But with JQL Search Extensions for Jira, you can use this query to find the issues you need:

project in (ABC, XYZ) AND issuetype in ("Change Request", Defect, Story) AND fixVersionReleaseDate <= "2022/07/01" AND fixVersionReleaseDate >= "2022/06/30"

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte

All comments

Tansu Akdeniz

Hi @Sudharsan

Is this Project -> Releases -> Release Date? Or a customfield?

If it is a cf, sample one:

project in (ABC,XYZ) and type in ("Change Request", Defect, Story) and "Release date[Date]" > "2022-07-01" and"Release date[Date]" < "2022-06-30"

Sudharsan_pjc749

Hi Tansu,

Thanks for the reply

Releases and Release Dates

Regards,

Sudharsan.G

Tansu Akdeniz

There is an open feature request for release date search. You can vote and watch JRACLOUD-22640. Please check workarounds in that page.

Sudharsan_pjc749

I have installed JQL Extensions Plugin with that can we filter data ?

Help will be appreciated

Charlotte Santos -Appfire-

Hi @Sudharsan

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

But with JQL Search Extensions for Jira, you can use this query to find the issues you need:

project in (ABC, XYZ) AND issuetype in ("Change Request", Defect, Story) AND fixVersionReleaseDate <= "2022/07/01" AND fixVersionReleaseDate >= "2022/06/30"

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte

Kateryna_v_SaaSJet_

Hi @Sudharsan

I see that your question has already been resolved, but for others who are looking for similar answers, I recommend reading the article: "16 Most Popular JQL Filters for SLAs in Jira Cloud".
There is a list of the most popular JQLs, and you may find them helpful for you.

They all work in Jira SLA or issue filters but can also be used for add-ons. I checked them in the SLA Time and Report add-on, which my company developed.

general sla grid- table report.png sla general configuration manager menu.png

It's much easier for beginners to configure SLA using advanced filters rather than JQL queries, so I recommend trying this SLA app.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software-cloud