[data grid] Row pinning with Server-side tree data

[atlanteh]

The problem in depth

I might be missing something, but with the new unstable_dataSource, how do I have a totals pinned row?
For example, you have a list of sales, and you want to show the total sum of sales, the revenue etc.. as returned by the server.
In regular grid, I would get this metadata and insert it as a pinned row, but with the grid, since the data is encapsulated inside the dataSource, I'm not sure what is the best why to do that..

Your environment

No response

Search keywords: sever-side, row pinning
Order ID: 56081

[michelengelen]

Hey @atlanteh the best way to do this would be to use aggregation, but as this is currently not implemented for the server-side data source feature (you can upvote and track #10860 for updates).

@MBilalShafi can we provide a workaround for this until aggregation lands?

[MBilalShafi]

@atlanteh Until we have an internal implementation, as a workaround, (assuming you have an endpoint that provides the aggregated value), either of these might work for you:

1. Use colDef.renderCell to pass a custom component for the aggregation cell, where you fetch the server-side value. https://codesandbox.io/p/sandbox/mystifying-sanne-tvcsqw (Though we could export GridFooterCell or make it a slot to make such a customization easier)
2. Use a custom aggregation function to use the server-side value stored in a state variable. https://codesandbox.io/p/sandbox/zen-sky-fgqxc9

Let me know if it helps.

[github-actions]

The issue has been inactive for 7 days and has been automatically closed.