dosubot[bot] commented on issue #32276: URL: https://github.com/apache/superset/issues/32276#issuecomment-2661587300
<!-- Greeting --> Hey @chrisdukeLlama! I'm here to help you with any bugs, questions, or contributions you have for Apache Superset. Let me know how I can assist you! <!-- Answer --> The logic for automatically applying filters to categorical searches in Superset is located in the `superset-frontend/src/filters/components/Select/buildQuery.ts` file. The code applies an `ILIKE` filter for string types, which is similar to `LIKE` but case-insensitive. If you want to use `LIKE` instead of `ILIKE`, you would need to modify the code to change the `op` value from `'ILIKE'` to `'LIKE'` <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/src/filters/components/Select/buildQuery.ts)</sup>. Additionally, the backend logic in `superset/models/helpers.py` handles different filter operators, including `LIKE` and `ILIKE`, in the SQLAlchemy query construction. This suggests that the backend already supports both operators, and you might be able to leverage this by adjusting the frontend logic to specify the desired operator <sup>[[2]](https://github.com/apache/superset/blob/master/superset/models/helpers.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/c45027da-b509-4956-8887-657e845c1daa?feedback_type=other)</sup> -- 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]
