Forums

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

Reports

Becky Ryba
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!
January 3, 2019

Is there a way to run a report to capture tickets created for a specific date and time parameter?

3 answers

0 votes
Ben Poulson
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.
January 3, 2019

For a more direct answer, here is the JQL query you would run to get all completed tickets (sorted newest-oldest) for project XXX created between December 3, 2018 and December 13, 2018 (arbitrary dates picked for example purposes):

 

project = "XXX" AND status = "Completed" AND createdDate >= "2018/12/3" AND createdDate <= "2018/12/13" ORDER BY created DESC

 

If you want tickets from, say, this month (instead of specific days), it would be:

 

project = "XXX" AND status = "Completed" AND createdDate >= startOfMonth() ORDER BY created DESC

 

Note: if using startOfMonth/Week/Day/Year(), if you put a number in the parenthesis, you can modify the amount of time (i.e. startOfMonth(-2) refers to two months ago (in January 2019, startOfMonth(-2) refers to November 1, 2018), the same applies to startOfDay(), startOfWeek(), etc.)

0 votes
Jack Brickey
Community Champion
January 3, 2019

@Becky Ryba, welcome to the Community. For sure you can do this. If you provide your specific goals I might be able to help more precisely. In the meantime the following is quite useful - Becoming-a-JIRA-Search-Ninja-The-secret-powers-of-JQL

0 votes
Victor Mutambuki
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.
January 3, 2019

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events