[question] Am I able to provide multiple rules to the initialState sortModel for DataGridPro

[ricyoung-fa]

The problem in depth 🔍

I am using DataGridPro with many columns. I want to provide multiple columns in the initialState sortModel.

In the documentation, I see only one sorting rule provided:
sortModel: [{ field: 'rating', sort: 'desc' }]

However, I want to know if it's possible to pass multiple rules to sortModel. For instance,

sortModel: [
  { field: 'rating', sort: 'desc' },
  { field: 'name', sort: 'asc' },
]

In this scenario, I would expect, all rows with 5 stars be sorted to the top. And within the 5 star rows, a secondary sorting is applied that sorts names in ascending order.

Thanks!

Your environment 🌎

`npx @mui/envinfo`

  Don't forget to mention which browser you used.
  Output from `npx @mui/envinfo` goes here.

Search keywords: datagrid default column sorting sortModel
Order ID: 67129

[alexfauquette]

It works, but you need to use the pro plan since multi sorting is a pro feature:

https://codesandbox.io/s/eloquent-bird-dgvcd8?file=/src/Demo.tsx

I case you did not know, you can experiment with demonstration by editing the code directly in the docs. Or by opening a codesandbox with this button

[ricyoung-fa]

Thanks for the response! @alexfauquette

I did attempt to change the demos, but I was changing the code in the [Initialize the sort model](Initialize the sort model) section, and did not notice that was DataGrid, and not DataGridPro.

I see it working in your demo now.

My org does have the pro plan, however, I'm still having trouble with my own implementation. I'm assuming that the sort model rules will obey any custom sort operator definitions, correct?

[cherniavskii]

I'm assuming that the sort model rules will obey any custom sort operator definitions, correct?

Correct.

I'm still having trouble with my own implementation

Feel free to open an issue with a minimal reproduction example, we will take a look 🙂