How to filter table data on client side

Wappler General How To
#1

Hello,
I can use a text box to filter results coming from a database using the URL and server connect but wondered, can the same thing be done using a JSON file or public API? I am looking to do something like this (https://www.w3schools.com/howto/howto_js_filter_table.asp)
Thanks and best regards,
Brian

#2

Hello,
Use the data view component for clientside filtering.

#3

Hello Teodor,
I am using a dataview for drop down filtering based on a product type. I will add another dataview to try out text searching.
Thanks :slight_smile:

#4

You can filter by a text input using the contains() or fuzzysearch() formatter option.

Data View Question - how to display?
#5

Hi Teodor,
I really like Dataviews! The data is filtered very quickly. One more question if I may? The searching looks for an exact match so ‘ArchiMate’ would be found but ‘archimate’ would not. Can it be made to be case agnostic?
Cheers,
Brian

#6

Yes, use the lowercase formatter for both the expression you use for a search value and the property you are searching.

#7

Thanks, Teodor. Have a good day :+1:

1 Like