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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.