Filtering

[MaxBernstetter]

Hey,

I am having the problem, that the filtering function only matches items which have the exact starting-value compared to the searchvalue. E.g., given this data: ["Apple", "applejuice", "Many apples"], none of these items would match the searchvalue "apple".

Only or the searchvalue "App", the first item would match, and so on...

I forked your repo and would like to edit the functionality so that, the filtering is:

• Case insensitive
• Matching a searchvalue also if it is incorporated within a compared value

Can you point me on the correct code-section? I already tried editing the lucene query

From:
`
// Process a string match (fails if the value does not start with the string)
const stringMatch = match("string", (docValue, testValue) => {
return (
!docValue || !docValue?.toLowerCase().startsWith(testValue?.toLowerCase())
);
});

To:
const stringMatch = match("string", (docValue, testValue) => { return ( !docValue || !docValue?.toLowerCase().includes(testValue?.toLowerCase()) ); });
However, had no luck in changing the filtering

Any help would be greatly appreciated :)

[poirazis]

Hello @MaxBernstetter
sorry for the delay !
The Lucene query is not my implementation, i just got it off budibase source.
i haven't figured out how to make it work like an SQL LIKE
If you do find a way, i would love to have it implemented !

For more information you could look at the bb source code of how the Dynamic Filter component uses it
https://github.com/Budibase/budibase/blob/develop/packages/client/src/components/app/dynamic-filter/DynamicFilter.svelte

Hope this helps !