Filtering search... how to do it with Wappler

[michele]

Hello,
I’d like to know if is possible to use Wappler to create an advanced filtering search without page refreshes.
I have a client who wants to create on his PHP-MySQL-Bootstrap website the classic filtering search form that is usually done on CMSs such as WordPress/WooCommerce.
This is an example of what he would like to apply on his website (I mean only the filtering search on the left column, no the e-commerce module):

eCommerce Demo - Gridbuilder ᵂᴾ

Is it possible to do this with Wappler?
If “Yes”, is there a tutorial/template to use as starting point?

Thanks.

[Teodor]

@michele

who wants to create on his PHP-MySQL-Bootstrap website the classic filtering search form that is usually done on CMSs such as WordPress/WooCommerce.

Hello,
Filtering data like that is not really related to Wordpress or any other CMS.

Yes, you can filter your data using different form inputs like checkboxes, radio buttons, text inputs etc.

Btw I thought you were already aware of this, being a long-time DMXzone customer

[michele]

Hello Teodor,
do you have a tutorial/guide to show me how to quickly set up a search structure with Wappler similar to the one I indicated in my message above?
Thanks.

[brad]

Hi @michele,

It’s pretty simple.

In server connect add a new server connect action and under GET add variables for each of your search fields … such as keywords, colour, etc. You should have one for every form field you are having in your search tool.

Then add your query to the action and filter your data by the variables you added.

Then add your server connect action to your web page and in the properties you will see your variables listed. In the bindings for each one bind them to the form elements that it belongs to.

Hope that gets you pointed in the right direction.

[michele]

Thanks Brad, I will buy a Wappler licence tomorrow to try it out.
The last time I used Wappler was almost two years ago so I’m a bit rusty and unfortunately I see that the documentation has not improved (although I see some good external resources made by other users)…

[brad]

And the community is as helpful as ever! It’ll all come back to you.

[bpj]

Hi @michele,
Depending on your aim/audience, you can also filter displayed results for a table on the client without additional SC calls by using the .where() formatter or the data view component. Assuming your initial query returned all the results (and there’s not too many - it seems that 2-3000 should be the max).

I quite often use something like this for the table repeat to search multiple fields for the filter text:

somedata.where('(field1+field2+field3).lowercase()',searchinput.value.lowercase(),'contains')

(making sure both are lowercase ensures case insensitivity)

[michele]

A question about the licence… can I build this filtering search module with the “Basic” or is necessary the “Pro” version?

[Teodor]

The basic license does not include the database tools. You need a pro license in order to use the query builder.

[michele]

Hello Teodor… is normal to have the VAT to pay with a valid “EU VAT number” in the “Billing section”?
It is usually removed during payment, so I ask you before proceeding if everything is correct. Thanks!

[Teodor]

If you are a company and have a VAT number, then you can get a Company license and enter your VAT number during the checkout so you won’t be charged for VAT.
For individual users, purchasing personal/individual licenses we charge VAT.