dosubot[bot] commented on issue #41454: URL: https://github.com/apache/superset/issues/41454#issuecomment-4810454119
<!-- Answer --> @murattkoc Good questions. Here's the situation: **Is this going to be fixed upstream?** As of now, this bug is **not fixed in the core codebase**. The root cause is in Flask-AppBuilder's `PermissionViewMenuApi` which doesn't declare the needed `search_columns` for dot-notation relationship fields. While several recent PRs have improved related areas (pagination, duplicates, rate limiting), the core filter column issue remains unresolved [[1]](https://github.com/apache/superset/discussions/40082#discussioncomment-17241627). It's unclear when a permanent fix will land since it requires changes in Flask-AppBuilder itself. **For production on k8s** — yes, you should put the workaround in your `configOverrides` section. Here's exactly what to add to your Helm `values.yaml`: ```yaml configOverrides: fix_permissions_filter: | from flask_appbuilder.models.sqla.filters import FilterContains from flask_appbuilder.security.sqla.apis import PermissionViewMenuApi from superset.security import SupersetSecurityManager class SupersetPermissionViewMenuApi(PermissionViewMenuApi): search_columns = ["id", "permission.name", "view_menu.name"] def _init_properties(self): super()._init_properties() for col in ["permission.name", "view_menu.name"]: self._filters._search_filters[col] = [ FilterContains(col, self.datamodel) ] class CustomSecurityManager(SupersetSecurityManager): permission_view_menu_api = SupersetPermissionViewMenuApi CUSTOM_SECURITY_MANAGER = CustomSecurityManager ``` This gets appended to `superset_config.py` at runtime [[2]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/installation/kubernetes.mdx#L113-L116) [[3]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/helm/superset/values.yaml#L142-L145), and Helm will automatically restart your pods when the config changes via checksum annotations [[4]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/helm/superset/templates/deployment.yaml#L60-L61). **Note:** If you already have a `CUSTOM_SECURITY_MANAGER` defined elsewhere in your config (e.g., for OAuth), you'll need to merge the `permission_view_menu_api` attribute into your existing custom security manager class rather than creating a separate one. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).* --- Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset). [](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=44e0b58e-38aa-4c26-9a28-3b737477f899) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset) -- 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]
