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

[Robin Hill]

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]

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 (RightStar)]

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 Brickey]

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

[Derek Fields (RightStar)]

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

[Jack Brickey]

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