Lacking ability to find partial match or use a "contains" in dynamic or table filters

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀

https://budibase.com

Other

22.47k stars 1.55k forks source link

Lacking ability to find partial match or use a "contains" in dynamic or table filters #13103

Open Solarbotics opened 8 months ago

Solarbotics commented 8 months ago

I am building an interface to a product database, and desperately need the ability to drill-down within the results from the data provider.

Here, the initial search is for "m3" which is parsed through my data providers SQL as 'like %m3%'

If I try to subfilter it with the ExtDescription term 'Quad', only the ExtDescription items starting with 'Quad' appear (excluding the first and second results of the first screenshot). The "Like" clause seems to only match from the beginning of the fields.

Neither column search or advanced filters seem to support this. I might revisit a similar internally developed tool where we built a javascript that searched and displayed only the DOM object lines that matched the drill-down searchbox.

Thank you for an otherwise very impressive tool!

linear[bot] commented 8 months ago

BUDI-8034 Lacking ability to find partial match or use a "contains" in dynamic or table filters

Solarbotics commented 8 months ago

I've done more deep-diving into the BB discussions, and found out that this seems to be a limitation of the "Internal DB lucene engine". Sounds like a bigger issue than I thought. Still, it's a valid feature request even though it seems somewhat impossible at the moment.

Again, thanks for an otherwise great tool!

Solarbotics commented 8 months ago

Discussing with my Dev, he mentioned we're using jquery datatables in our own tool. A quick search located this promising plugin. Lists as a "v1.0.0" and does appear to present a datatables component when nested with a data provider, but unfortunately seems to have some broken configurations that disallow most functionality.

Always happy to hear from a more proficient datatables user on how it could be configured!

Solarbotics commented 8 months ago

Some progress! Digging into the "components\Table.svelt" file lines 71..87, it looks like the search parameters were hard-coded to only work on columns named 'title', 'description', and 'date'. Renaming some of my data provider fields made this functional!

Oh, getting close to a solution!