"like" doesn't work

[lipan1024]

"Like" doesn't work when I use "tables" as a filter, but "like" works when I use "queries" as a filter

[mjashanks]

Hi @lipan1024 - can you be more specific? I don't know what yo mean by "Like". Can explain what you are trying to do, maybe with a few screenshots?

[lipan1024]

~When I use a table to provide data:

The filter did not work.

~When I use custom query to provide data:

This is what I wanted!

[lipan1024]

I don't want to use equal, because I want to have data when the filter is empty...

[lipan1024]

@mjashanks

[mjashanks]

Thanks for the extra info. It seems as though "Like" is broken, as you point out. Also, I think that when your options picker has no value, the condition should not be applied - as you have shown, this is also not the case!

However, you can still achieve what you need, using "Conditions":

1. First of all, add an "All" option to your picker. This will be used to display all values
2. In your Data Provider's filters, remove any filters
3. Now, on your data provider, click "Configure Conditions"
4. Set a condition to "Update Setting" > "Filters", then click "Define Filters"
5. Add your filter, as before, then click save
6. Now, set your condition to only apply if your options picker Not Equals > All

Budibase.mp4

I think it would be nice to add a custom WHERE clause in here - it would provide alot more flexibility.

[lipan1024]

That's a good idea, thank you~

[v3ss0n]

Like is still broken it seems.

[ecxs]

Like does not seem to work for me either ... version 2.1.28

[v3ss0n]

i think no issue about this is created yet