How to create a search and set it for 1000 of the 1555 records I need?

Question

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

Jack Brickey · Answer

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

Derek Fields _RightStar_ · Answer

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

Jack Brickey · Answer

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. ;-)