A search form is a great way to use URL parameters in a user friendly way. It allows a user to search for specific values in specific fields using plain values and wildcards.To launch a search form we need to create two separate pages: A page containing the search...
Filters
URL parameters
To add a filter on a specific table column you can add an URL argument to your request that follows the following name convention:wpda_search_column_<column_name>Only GET requests are supported for data tables!ExamplesRequest:...
Search Panes
Search Panes are a user friendly way to help users to filter table data. This is a premium feature.Inline demoAdd Search Panes to a data tableClick the Config button to select columns.Manually adding Search Panes to a data tableThe following...
Search Builder
The Search Builder is a user friendly interface that allows your visitors to interactively query your table data. It supports numeric, text and date columns. The Search Builder is a premium feature.Inline demoClick ADD CONDITION to create a custom query.[wpdataaccess...
Geolocation search
To add geolocation range search to a data table, geolocation support has to be enabled first. Once enabled, it can be added using advanced table options. Enable geolocation support for a custom database table (start here) Demo of a data table using geolocation range...
Advanced search
Individual column searchThe 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. Enable individual column search Inline demo individual column searchThis feature adds...
Static filters
There are three ways to add a static filter to a data table: Default where clause Shortcode parameters 1. Default where clauseData Tables allows plugin users to add any default where clause (click image below to enlarge). This includes subqueries and other more...
Recent Comments