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 create a search and set it for 1000 of the 1555 records I need?

I need to see all 1555 but a message displayed indicating I can only see 1000 records.  I need to see 1000 and then set the rest for 555 but I don't know what the syntax would be.  Thanks.  This is what I have so far:

 

assignee = currentUser() AND project = ecosit AND status in (Closed) ORDER BY cf[11310] ASC, created ASC, reporter ASC, key ASC, priority ASC, status DESC

1 answer

0 votes
Jack Community Leader Feb 03, 2020

You might find this article useful - increase-issue-limit-for-excel-exports-in-jira-cloud 

basically you have to perform two searches. Note that trying to "see" even 1000 issues would be a challenge as you would be paging forever.

Derek Fields Community Leader Feb 03, 2020

I find when I am looking at large  numbers of issues, it is easier to download the query to Excel, where  I can do whatever number crunching or further filtering that I want to do. If you use the Export function, you will get all 1555 rows in the CSV file.

Jack Community Leader Feb 03, 2020

Hi Derek, that isn't exactly true, at least not in cloud. the search only returns 1000 and then you have to change the query to get the next "1000", etc. Now, recently they have released an extension for Excel for running an JQL query directly from w/in Excel which will grab more that 1000. I have also recently noticed excel and google sheets icons at the top of my search results but I was just testing and it didn't seem to work. Keep in mind here that running a massive query will absolutely impact your instances performance so my advice is to run during quite times. ;-)

 

excel extension.jpg

 

Issue_navigator_-_JIRA.jpg

Derek Fields Community Leader Feb 03, 2020

I am  so used to working in Server that I forget the Cloud limitations, which are painful.

Jack Community Leader Feb 03, 2020

true but there are also a lot of benefits as well. ;-)

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