Row Limit for Excel Download

[rsnell]

I have a grid that has the potential to return a significant number of records. I also have download to Excel turned on with a maximum number of rows of 50,000. Over 5,000 records should be returned (maybe 6,500). If paging is turned off, not all records are displayed in the grid. The download tops out at 5,000 rows. If paging is turned on, all records can be retrieved in the grid. However, the download still tops out at 5,000 rows. I also tried legacy Excel, but that doesn't impact the row count returned. Is this a bug? I'm using version 6.3.20251222.0.

[Johnny Major]

That is not a bug. If a grid is not paging, the maximum number of records returned is 5,000.

[rsnell]

For the paging grid, the Excel download still tops out at 5,000 rows. I would expect the same number of rows to be returned that are in the grid. Also, what's the purpose of the maximum row count for download if there's a 5,000 row limit?

[Johnny Major]

It shouldn’t be limited to 5,000 when the grid is paging. Is it just the Excel download that’s limited to 5,000 when paging, or is the grid itself limited as well?

[rsnell]

It's just the download

[sean.lanktree]

Few questions:
When you attempt the excel download are you getting a popup window with "Current Page" and "All Pages" options?
What is your pagesize set to?
What does the paging toolbar show for total record count?

[rsnell]

I get the pop-up and I'm selecting 'All Pages'.

Page size is 100.

The paging toolbar shows 63 pages and 6,203 rows.

The download cuts off at 5,000 rows.

[sean.lanktree]

Just need to confirm....you have NO value in the "Maximum Rows" input field in the grid widget configuration, correct?

[rsnell]

That's correct

[sean.lanktree]

OK, can you try the following? Bring up the Developer Tools > Network: when you click "All Pages" do you see 2 calls to VVCALL? If so, can you post back what the second call looks like under "Payload" and "Preview".

[rsnell]

I don't see 2 VVCALL. I just see 2 getData

[sean.lanktree]

OK, can you post back what the second call looks like under "Payload" and "Preview".?

[rsnell]

I don't see anything that refers to Payload or Preview

[rsnell]

Is there anything else we need to do on this?

[rsnell]

I've attached what I see in the console. You can see there's a 5,000 limit listed.