dosubot[bot] commented on issue #30413: URL: https://github.com/apache/superset/issues/30413#issuecomment-2378549841
<!-- Greeting --> Hey @volume8208! I'm here to help you with the issue you're facing in Superset. I'm a bot designed to assist with bug resolutions, answer questions, and guide you on becoming a contributor. Let's dive into resolving the problem together! <!-- Answer --> The issue with filters applied through the Dashboard's Filter UI not working for a Google Sheets data source, while manually applying SQL WHERE filters in SQL Lab works as expected, is likely due to compatibility checks and scope management in the Dashboard's Filter UI. 1. **Compatibility Checks**: The filters are checked for compatibility with the datasource. If the filters are incompatible, they are marked as `IndicatorStatus.Incompatible` and are not applied. This could be why the filters are not working when applied through the Dashboard's Filter UI <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/components/nativeFilters/selectors.ts)</sup>. 2. **Scope Management**: The function `useSelectFiltersInScope` ensures that only filters within the active scope of the dashboard are applied. If the filters are out of scope, they will not be applied <sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/src/dashboard/components/nativeFilters/state.ts)</sup>. 3. **Error Handling**: The error "NO_COLUMN: null" is generated when a column does not exist in the datasource. This is handled using the `SupersetError` class with the `COLUMN_DOES_NOT_EXIST_ERROR` type <sup>[[3]](https://github.com/apache/superset/blob/master/superset/errors.py)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset/connectors/sqla/models.py)</sup>. To address this issue, ensure that the filters are compatible with the Google Sheets data source and within the active scope of the dashboard. Additionally, verify that the columns referenced in the filters exist in the Google Sheets data source. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
