I have a large table with 300K entries containing terms which often contain the words 'mens' or 'womens'. I've made the list searchable and have discovered that when I search for just the 'mens' entries, the 'womens' entries are also appearing since 'mens' is contained in 'womens'. Is there a way to be able to isolate just the 'men' results without the 'women' results? I've tried turning on 'exact filtering' but this does not help. Any ideas?
Smart search will find all words separately that are typed in the search bar. Now for your case when the table is server side my suggestion is to make some more columns( example: jacket, color, mark) and all of that columns will have separately their values ( for example, color will have red blue green, mark will have gucci Armani etc)
You can also take a look at our add-on on this link so you can use cascade filtering for this kind of tables.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
Thanks.
Hi there -
I have a large table with 300K entries containing terms which often contain the words 'mens' or 'womens'. I've made the list searchable and have discovered that when I search for just the 'mens' entries, the 'womens' entries are also appearing since 'mens' is contained in 'womens'. Is there a way to be able to isolate just the 'men' results without the 'women' results? I've tried turning on 'exact filtering' but this does not help. Any ideas?
Here's a small sample of the data:
Thanks in advance!
John
HI John,
Thank you for your purchase.
Can you please tell me is that table server side or non server side.
For server side tables it is not possible to have smart search but for non server side it is possible with some code modification.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for getting back Bogdan. The table is indeed server side due to the large amount of data.
Good to know if this is possible with some code modification!
I found another instance where the search isn't working optimally.
For instance if someone is looking for a 'red jacket' from this list only the first option shows up in the search results:
- red jacket gucci
- jacket gucci red
- puffer red jacket
Would smart search be able to find all the instances of red jackets in the above example?
Thanks,
John
HI John
Smart search will find all words separately that are typed in the search bar.
Now for your case when the table is server side my suggestion is to make some more columns( example: jacket, color, mark) and all of that columns will have separately their values ( for example, color will have red blue green, mark will have gucci Armani etc)
You can also take a look at our add-on on this link so you can use cascade filtering for this kind of tables.
Hope this can help you out.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the advice Bogdan. Seems like this solution will help.I have your add-on so this seems like a great way to use it.
Cheers,
John
Hi John,
You are welcome.
Glad to be able to help you.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables