[data grid] Support asc_nulls_first and desc_nulls_last in sortingOrder

[2ndPINEW]

Duplicates

• I have searched the existing issues

Latest version

• I have tested the latest version

Summary 💡

When defining GridCol, I would like to set it as sortingOrder: ['asc_nulls_first', 'desc_nulls_last'].
When clicking on a column to sort, I'd like the orderBy to toggle between asc_nulls_first and desc_nulls_last, and I want the arrows in the table headers to point in the specified direction."

Examples 🌈

No response

Motivation 🔦

When creating queries with a GraphQL client, being able to specify this in the field definition would eliminate the need for conditional branching in other parts, keeping the code streamlined and simple.

Order ID 💳 (optional)

No response

[MBilalShafi]

Are you looking for https://mui.com/x/react-data-grid/sorting/#custom-comparator to modify how the default sorting works in the Grid?

[github-actions]

The issue has been inactive for 7 days and has been automatically closed. If you think that it has been incorrectly closed, please reopen it and provide missing information (if any) or continue the last discussion.