richardfogaca opened a new issue, #38483: URL: https://github.com/apache/superset/issues/38483
### Discussed in https://github.com/apache/superset/discussions/25358 <div type='discussions-op-text'> <sup>Originally posted by **dolfandringa** September 21, 2023</sup> I would like to use the dashboard filters to use a value for `LIKE` queries using jinja templating. Currently, if I add a filter for a column of type "Value" to a dashboard, I can only select a full value from the dropdown. It isn't possible to enter anything for partial text matches. I see three optionsd to address this: 1. Using the same Value filter type, but add an boolean/checkbox option to allow partial matches. Right now, when you partially type a value, and hit enter, it disappears. It would be great if the value would be kept, even if it doesn't completely match an existing value. This partial value could then be retrieved in jinja templates, and be used for instance like this in the underlying query: `column LIKE '%{{filter_values("filter_name")}}%'` 2. Have a dedicated "Text" filter type that is just a text box, but works the same way as above with respect to jinja templates and the query. It just is a different filter typoe instead of adding a checkbox to the current Value filter type. 3. Have dedicated `beginswith`, `endswith` and `contains` filter types that don't require jinja templating in the queries. This is probably the nicest feature, but I guess also the hardest one to implement. I would really like people's opinion about this, and would be happy to contribute in the form of a SIP and PR if there is consensus. </div> -- 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]
