dosubot[bot] commented on issue #35279: URL: https://github.com/apache/superset/issues/35279#issuecomment-3332760718
<!-- Answer --> Superset's backend supports multi-field sorting for table charts, but the current frontend only sends one sorting field to the backend when server-side pagination is enabled. Even though the UI shows a tooltip like "Shift + Click to sort by multiple columns," only the first selected sort field is actually used in the query, so true multi-field sorting isn't possible out of the box right now. This limitation is in the frontend state management and query construction, not the backend API ([code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-table/src/buildQuery.ts)). If you need multi-field sorting, you have a few options: pre-sort your data in the dataset or database, create a calculated column that encodes your desired order, or modify the frontend code (especially in the TableChart and DataTable components) to propagate all selected sort fields to the backend, which already supports them ([frontend code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-table/src/TableChart.tsx)). There are no built-in workarounds or configuration switches for this in the current UI. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/402eebc2-a19e-443f-b85f-2310a0e96565?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35279) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
