Edit table data with wildcards

[0infinitive0]

when edit table data, is there a way to filter with wildcards like in Azure data studio?

[ghiscoding]

they use Slickgrid-React (which I maintain) and for local filters (what is currently fetched and in memory) you could use * for StartsWith or EndsWith but not both (e.g. John* or *Doe) or any operators should work in the filter input as well (>, >=, <, <=, !=, <>, or even Between separated by .. like 10..25)

If however you're talking about filtering by updating the SQL query and fetch new data, then you should follow PR #22045

[0infinitive0]

i was talk something like this:

this is not how it work i suppose:

[ghiscoding]

that won't work you can only use 1 operator at a time in a local input filter. You're trying to use 2 operators, the Between (..) and the Starts With (xyz*). Slickgrid-React uses regex to extract the operator, and can only extract 1 operator at a time.. and on top of that the filter you've tried is also invalid because si..controller means anything Between "si" and "controller" and that's invalid, it could work with "controller..si" because it uses the ASCII table and "si" is higher than "controller" and so nothing will be returned... but I think what you meant to filter was something like (Starts With "si") and (Ends With "controller") and the only way to get this working is to duplicate the same field/column and have 2 separate filters: first column would have Starts With (e.g. "si*") and the second column would have Ends With (e.g. *controller) and that would work...

but PR #22045 was merged and will probably be released in v1.43 and that should help you tweak the SQL query with more filters (see animated gif in the PR)

The important difference with this new merged PR is that the existing filters on top of each columns are only accepting 1 operator and are only using local data (only what was fetched), but the new Filter section in PR #22045 will allow you to tweak the SQL query by applying extra filters (will modify the data to fetch)