The problem in depth

Using the DataGridPremium with rowGrouping and a dataSource. Our initial result for the top level group returns 2000+ records. Our data has a group depth of 2. We have limited filtering to just these 2 fields for simplicity while we work out any bugs in our setup and data design. If we add filters for either one or both fields, we get back the expected results. If we clear these filters the data grid only displays 100 results. I have recreated this using the commodities demo, switching the group to use the 'desk' item since there are many more results to better replicate our large dataset issue. Removing the pagination parameter allows between 800 and 900 results. Once a filter is added such as 'Commodity' contains 'Soybean', we can see the results limited to something reasonable, such as 150 or so. If this filter is cleared, the data grid resets to only showing 100 results with no pagination input from the data grid's datasource or elsewhere.

To reproduce: Create a filter such as 'Commodity contains soy'. See as the results shrink to the appropriate amount as expected. Clear the filter either individually or 'clear all'. See the results limited to 100 when there should be an amount near 800.

reproduction

Your environment

  System:
    OS: macOS 15.4.1
  Binaries:
    Node: 22.15.1 - ~/.nvm/versions/node/v22.15.1/bin/node
    npm: 10.9.2 - ~/.nvm/versions/node/v22.15.1/bin/npm
    pnpm: Not Found
  Browsers:
    Chrome: 137.0.7151.120
    Edge: Not Found
    Safari: 18.4
  npmPackages:
    @emotion/react: ^11.11.4 => 11.14.0 
    @emotion/styled: ^11.11.5 => 11.14.0 
    @mui/core-downloads-tracker:  7.1.1 
    @mui/icons-material: ^7.1.0 => 7.1.1 
    @mui/material: ^7.1.0 => 7.1.1 
    @mui/private-theming:  7.1.1 
    @mui/styled-engine:  7.1.1 
    @mui/system:  7.1.1 
    @mui/types: ^7.4.2 => 7.4.3 
    @mui/utils:  7.1.1 
    @mui/x-data-grid: ^8.5.2 => 8.5.2 
    @mui/x-data-grid-premium: ^8.5.2 => 8.5.2 
    @mui/x-data-grid-pro: ^8.5.2 => 8.5.2 
    @mui/x-internals:  8.5.2 
    @mui/x-license: ^8.3.1 => 8.5.2 
    @mui/x-telemetry:  8.5.2 
    @types/react: ^18.3.1 => 18.3.23 
    react: ^18.3.1 => 18.3.1 
    react-dom: ^18.3.1 => 18.3.1 
    typescript: ^5.2.2 => 5.8.3 

Search keywords: DataGridPremium pagination 100 results clear filters rowgroupng row grouping

Order ID: 114932