Filters

Posts under the "Filters" category

Search form

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...

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...