Forums

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

How to pull a report or a list

cheryl.carter November 25, 2019

Good day.  I simply want a list or report (whatever its called) of all my epics and tasks this year - how do I do that?

1 answer

0 votes
Jack Brickey
Community Champion
November 25, 2019

Hi Cheryl, see if any of this helps...

  • Created this year - issuetype = epic and createdDate >= startOfYear()
  • Completed this year - issuetype = epic and status = done and status was not done BEFORE startOfYear()
  • Created this year & completed this year - issuetype = epic and createdDate >= startOfYear() and status = done and status was not done BEFORE startOfYear()

let me know if you are looking for something slightly different.

cheryl.carter November 25, 2019

Thank you none worked for me including a response on the first one at least of 

Error in JQL Query: Expecting either a value, list or function but got '='. You must surround '=' in quotation marks to use it as a value. (line 1, character 38).

 I appreciate your assistance.  We were NEVER adequately training on anything other than JIRA entry

Jack Brickey
Community Champion
November 25, 2019

they work fine for me. I am on cloud but expect the server version is the same where this is concerned. please post a screenshot of the JQL you entered and the error. you can also begin typing the jql as you see it and select from the auto-complete offerings.

cheryl.carter November 25, 2019

I cannot copy/paste either.  i use snag it but it is not pasting.  cannot figure out how to take a picture and upload.  my query was:

"Assigned Team" = "T&R" AND issuetype = epic and createdDate > = startOfYer(2019)

message was 'No issues were found to match your search

Try modifying your search criteria or creating a new issue'

Jack Brickey
Community Champion
November 25, 2019

yep paste doesn't work in the Community which is frustrating. You can save to your desktop and click the camera icon in the reply to import.

if the above is a copy and paste of your query there are some syntax errors. there is a space between the ">" and "=" which is invalid. "startofyear" is misspelled. You can't enter the year in the "()". the copy and paste should work here...

"Assigned Team" = "T&R" AND issuetype = epic and createdDate >= startOfYear()

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events