GitHub user dosubot[bot] added a comment to the discussion: Superset/Jinja Template filtering
<!-- Greeting --> Hi @yappiverse! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> Superset does not natively support displaying a label to the user while passing a different value (like an id) to the query in filter controls. The value that gets passed to your Jinja template is determined by the column you map in the filter configuration—if you map to "label", the label is passed; if you map to "id", the id is passed. There is no built-in way to display one column and pass another as the filter value. The concatenation and splitting workaround you described is the standard approach in Superset for this scenario, and there isn't a more streamlined method available as of now. This limitation is reflected in both the frontend filter configuration and the backend Jinja templating logic ([reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/jinja_context.py#L287-L774)). If you want to avoid this workaround, you would need to map your filter directly to the "id" column (so the value is passed), but then users will see the id instead of the label in the UI. There is currently no native support for label/value separation like you might find in other BI tools. <!-- 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/b084d794-953a-4130-8e19-995335cbf813?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b084d794-953a-4130-8e19-995335cbf813?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](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/discussions/35979) GitHub link: https://github.com/apache/superset/discussions/35979#discussioncomment-14867791 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
