Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to pull a report or a list

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 Community Leader Nov 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.

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 Community Leader Nov 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.

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 Community Leader Nov 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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you