dosubot[bot] commented on issue #36775: URL: https://github.com/apache/superset/issues/36775#issuecomment-3677647172
<!-- Answer --> This is a confirmed regression: integer filter values are sorted as strings (lexicographically) in some Superset versions, so you see "1, 10, 100..." instead of "1, 2, 3..." as expected. The issue was fixed in 6.0.0RC2 ([PR #34858](https://github.com/apache/superset/issues/35008)), but the fix did not make it into the 6.0.0 final release and the problem reappeared. The regression is tracked in multiple issues and was addressed again in later PRs ([#35130](https://github.com/apache/superset/pull/35130), [#35155](https://github.com/apache/superset/pull/35155), [#35152](https://github.com/apache/superset/pull/35152)), which are now merged into the 6.0-bug-fixes branch and master—so the fix will be in RC3 and newer builds ([discussion](https://github.com/apache/superset/issues/35331)). There is no user-level workaround or configuration option for affected versions; the only way to resolve this is to upgrade to a version that includes the fix. If you need a temporary solution, you would have to patch the frontend code or ensure the backend query for filter values sorts numerically, but this is not officially documented or supported. For complex sorting, use the filter UI controls and structured format—raw SQL strings for sorting are no longer supported. If you need to sort by a custom order, create a calculated column or metric and sort by that metric in the filter config. References: - [Original issue #35008](https://github.com/apache/superset/issues/35008) - [Regression/fix timeline and details](https://github.com/apache/superset/issues/35331) - [PR #35130](https://github.com/apache/superset/pull/35130) - [PR #35155](https://github.com/apache/superset/pull/35155) - [PR #35152](https://github.com/apache/superset/pull/35152) <!-- 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/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/64ec445b-d15e-4852-a950-3c4c98fc4fbf?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=This%20is%20a%20confirmed%20regression%3A%20integer%20filter%20values%20are%20sorted%20as%20strings%20%28lexicographically%29%20in%20some%20Superset%20versions%2C%20so%20you%20see%20%221%2C%2010%2C%20100...%22%20instead%20of%20%221%2C%202%2C%203...%22%20as%20expected.%20The%20issue%20was%20fixed%20in%206.0.0RC2%20%28%5BPR%20%2334858%5D%28https%3A//github.com/apache/superset/issues/35008%29%29%2C%20but%20the%20fix%20did%20not%20make%20it%20into%20the%206.0.0%20final%20release%20and%20the%20problem%20reappeared.%20The%20regression%20is%20tracked%20in%20multiple%20issues%20and%20was%20addressed%20again%20in%20later%20PRs%20%28%5B%2335130%5D%28https%3A//github.com/apache/superset/pull/35130%29%2C%20%5B%2335155%5D%28https%3A//github.com/apache/superset/ pull/35155%29%2C%20%5B%2335152%5D%28https%3A//github.com/apache/superset/pull/35152%29%29%2C%20which%20are%20now%20merged%20into%20the%206.0-bug-fixes%20branch%20and%20master%E2%80%94so%20the%20fix%20will%20be%20in%20RC3%20and%20newer%20builds%20%28%5Bdiscussion%5D%28https%3A//github.com/apache/superset/issues/35331%29%29.%0A%0AThere%20is%20no%20user-level%20workaround%20or%20configuration%20option%20for%20affected%20versions%3B%20the%20only%20way%20to%20resolve%20this%20is%20to%20upgrade%20to%20a%20version%20that%20includes%20the%20fix.%20If%20you%20need%20a%20temporary%20solution%2C%20you%20would%20have%20to%20patch%20the%20frontend%20code%20or%20ensure%20the%20backend%20query%20for%20filter%20values%20sorts%20numerically%2C%20but%20this%20is%20not%20officially%20documented%20or%20supported.%0A%0AFor%20complex%20sorting%2C%20use%20the%20filter%20UI%20controls%20and%20structured%20format%E2%80%94raw%20SQL%20strings%20for%20sorting%20are%20no%20longer%20supported.%20If%20you%20need% 20to%20sort%20by%20a%20custom%20order%2C%20create%20a%20calculated%20column%20or%20metric%20and%20sort%20by%20that%20metric%20in%20the%20filter%20config.%0A%0AReferences%3A%0A-%20%5BOriginal%20issue%20%2335008%5D%28https%3A//github.com/apache/superset/issues/35008%29%0A-%20%5BRegression/fix%20timeline%20and%20details%5D%28https%3A//github.com/apache/superset/issues/35331%29%0A-%20%5BPR%20%2335130%5D%28https%3A//github.com/apache/superset/pull/35130%29%0A-%20%5BPR%20%2335155%5D%28https%3A//github.com/apache/superset/pull/35155%29%0A-%20%5BPR%20%2335152%5D%28https%3A//github.com/apache/superset/pull/35152%29) [](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/36775) -- 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]
