Hello I have created a browse/filter/search application and I am having a problem with the Global table search field.
Based on the description of this field behavior:
"If the table does not use server-side processing feature, it will also search by multiple parts, e.g. input “Asia 12” will search by both values “Asia” and “12” in all cells. In tables with server-side processing this is not implemented because of implied performance burden." -- /documentation/general/frontend-section-overview/
I would expect that I could put 2 terms in the box and the table would return results for both terms. But I do not find this is how it works -- I put in one term and then as soon as I start typing the second word, everything disappears unless there is a record with those 2 words exactly and in that order.
About my table -- there is a column of hidden data "Products", but I have maintained the search form input for that column -- the "products" cells have a bunch of text that is perfect for the search/filter but not something we want to display.
So, is there any way to get an "OR" search - because that is what I am reading and I do not have server side processing. That input is behaving as AND, just like any of the other inputs.
Sorry for the inconvenience, but with or without serverside processing global search use AND for search values. We will change this in our documentation. Thank you for reporting this. It's require some code customization for logic that you request.
Hello I have created a browse/filter/search application and I am having a problem with the Global table search field.
Based on the description of this field behavior:
"If the table does not use server-side processing feature, it will also search by multiple parts, e.g. input “Asia 12” will search by both values “Asia” and “12” in all cells. In tables with server-side processing this is not implemented because of implied performance burden." -- /documentation/general/frontend-section-overview/
I would expect that I could put 2 terms in the box and the table would return results for both terms. But I do not find this is how it works -- I put in one term and then as soon as I start typing the second word, everything disappears unless there is a record with those 2 words exactly and in that order.
About my table -- there is a column of hidden data "Products", but I have maintained the search form input for that column -- the "products" cells have a bunch of text that is perfect for the search/filter but not something we want to display.
So, is there any way to get an "OR" search - because that is what I am reading and I do not have server side processing. That input is behaving as AND, just like any of the other inputs.
Thank you, Kim Kaiser
Hi Kim,
Thank you for your purchase.
Sorry for the inconvenience, but with or without serverside processing global search use AND for search values. We will change this in our documentation. Thank you for reporting this. It's require some code customization for logic that you request.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables