Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

JQL query for SD Issues that didn't closed before 1 Week.

Akshay Tanpure
Akshay Tanpure
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 18, 2023

Can someone help me with a query to pull all SD issues which didn't closed before 1 Week or resolved after 1 week, needed data of 1 month span.

 

Answer
Watch
Like Be the first to like this
280 views

1 answer

1 vote
Trudy Claspill
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
May 18, 2023

Hello @Akshay Tanpure 

Welcome to the Atlassian community.

Jira does not natively support creating JQL that will compare one issue date field to another issue date field.

You could use Automation for Jira to do that comparison and set a custom field in the issue to note if the issue was closed in less than or more than one week, and then base your JQL on that custom field.

Or you could look for a third party app to add to your system that could add the JQL functionality you need.

View More Comments
Akshay Tanpure
Akshay Tanpure
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 18, 2023

Thank you!

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events