Individual column search #
The premium version of the plugin supports a number of advanced search options. To search individual columns of a data table, this feature needs be enabled.
Inline demo individual column search #
This feature adds searchboxes to the table footer.
| ID | Lastname | Firstname | Gender | Date Of Birth | Address | Zipcode | City | County | Country | Phone No | Registration Date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | Lastname | Firstname | Gender | Date Of Birth | Address | Zipcode | City | County | Country | Phone No | Registration Date |
Use option wpda_searchbox in the table options advanced column to add searchboxes to the header, footer or both:
{ "wpda_searchbox": "header" }{ "wpda_searchbox": "footer" }{ "wpda_searchbox": "both" }Setting option wpda_searchbox to none disables individual column search for a specific data table. Thanks for the tip Charles!
{ "wpda_searchbox": "none" }Search and list box placeholder prefixes #
Examples #
Add Italian translation
{ "wpda_search_placeholder_prefix": "Ricerca" }Remove prefix
{ "wpda_search_placeholder_prefix": "" }Remove prefix and add search icon
{ "wpda_search_placeholder_prefix": "icon" }Removing placeholders #
It is also possible to completely remove the placeholders with option wpda_search_placeholder.
Examples #
{ "wpda_search_placeholder": "true" }
{ "wpda_search_placeholder": "false" }
{ "wpda_search_placeholder": "icon" }Combining options #
You can also combine wpda_search_placeholder_prefix and wpda_search_placeholder.
{
"wpda_search_placeholder_prefix": "icon",
"wpda_search_placeholder": "false"
}Styling searchboxes #
All searchboxes and listboxes contain CSS class wpda_search_textbox, which can be used for styling. Additionally, the column name is added as a CSS class as well, for individual searchbox styling.
Hi
is it possible for Data Tables to publish data on search, instead of publishing 10 database entries at the same time.
thank you
Hi Mmeli,
Yes, that is possible with the premium. Please see this page:
https://wpdataaccess.com/docs/data-explorer-settings/search-settings/
Section: Search engine like search
Hope this helps,
Peter
Hi Peter,
I’m really enjoying your program, it’s excellent! Is there a way to either not show the number of entries or max it out at a certain number like “10”. I was able to set the default but don’t want users to have the option to select 100 rows.
Thank you very much,
Burt
Hi Burt,
You can hide the length changing input control with the dom option. The default dom value is
"lfrtip"where l represents the length changing input control. Please enter the following JSON in your advanced table options to remove the control from your publication:{ "dom": "frtip" }More information about the dom option can be found here:
https://datatables.net/reference/option/dom
You can also change the list values and default using the advanced table options. Please have a look at options pageLength and lengthMenu:
https://datatables.net/reference/option/pageLength
https://datatables.net/reference/option/lengthMenu
Example: add the following JSON to your advanced table options to show 10, 20 and 30 in the list and set the default to 20.
{ "pageLength": 20, "lengthMenu": [10,20,30] }Hope this helps,
Peter
Is it possible to do an exact match search through the search field instead of a “contains” search?
Hi Andrea,
For exact search you need to change the search strategy for your table. This is explained here:
https://wpdataaccess.com/docs/data-explorer-settings/search-settings/
This feature requires a premium license.
Hope this helps,
Peter