dosubot[bot] commented on issue #35279: URL: https://github.com/apache/superset/issues/35279#issuecomment-3332302211
<!-- Greeting --> Hi @xianggao-1020! I'm [Dosu](https://go.dosu.dev/dosubot) and Iām helping the superset team. <!-- Answer --> This is a regression in Superset 6.0.0 RC2: the backend now enforces a structured format for sorting, so the "sort query by" field expects a list of tuples like `[('ds', False), ('name', False)]` (where `False` means descending), not a raw SQL string like `ds desc, name desc` as in 5.0.0. The frontend only allows selection from known columns/metrics, with no support for freeform SQL in the sort field. This change affects all databases, not just Doris, and comes from recent refactors and stricter schema validation in the chart query API ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/charts/schemas.py)). To resolve this, use the UI controls to select your sort columns and order, rather than entering custom SQL. If you need more complex sorting, you may need to create a calculated column or metric first, then sort by that. There are no documented workarounds for restoring the old behavior. <!-- 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/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b100e0be-7b7a-4525-ac18-8a00d9eadbcc?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]
