Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need an advanced JQL filter for below requirement

Sudharsan
Contributor
July 27, 2023

 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

3 answers

1 accepted

0 votes
Answer accepted
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 10, 2023

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

1 vote
Tansu Akdeniz
Community Champion
July 27, 2023

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
Contributor
July 27, 2023

Hi Tansu,

Thanks for the reply

Releases and Release Dates

 

Regards,

Sudharsan.G

Like John Funk likes this
Tansu Akdeniz
Community Champion
July 27, 2023

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

Sudharsan
Contributor
August 9, 2023

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

Help will be appreciated 

0 votes
Kateryna_v_SaaSJet_
Atlassian Partner
November 6, 2023

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.pngsla 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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events