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
Posts under the "Filters" category
URL parameters
There are two ways to use URL parameters: Add them explicitly to a default where clause Let the plugin add them automatically to a query 1. Add a URL parameter to a where clauseThis feature allows plugin users to limit query results based on URL arguments and supports...
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 two ways to add a static filter to a data table: Default where clause Shortcode parameters 1. Default where clauseThe default where clause supports conditions, subqueries and other more complex filters as long as it contains valid SQL.Using plugin...
Recent Comments