Report based off Jira ticket for this year

Qasim.Mateen
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!
April 14, 2023

My team and I are attempting to create a report on confluence with our Jira items for our project.

We have successfully displayed ALL of our Jira tickets and I can filter by the fields in the tickets (for ex; Sprint, due date, start date, etc.)

I was wondering if we can create a filter based off when the ticket was created (like a date range of when it was created). I see that in our Jira tickets that the created date is not a field but is being tracked in each of our tickets. There has to be a way to make a report and filter based off that data.

1 answer

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 15, 2023

Hi @Qasim.Mateen , you could certainly use JQL to create a filter based on a date range. Here is some documentation that might help - advanced-search-reference-jql-fields 

here are some examples...

project = abc and created >= startofyear() ... this will find all issues created in project ABC since January 1st of the current year

project = abc and duedate < startofday() and resolution is empty ...this will find all open issues that are past due as of today. 

Suggest an answer

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

Atlassian Community Events