jui_filter_rules

jui_filter_rules is a jQuery Data filtering plugin (query builder).

It is free and Open Source under MIT license.

View the Demo

Download from Github

Version

Current version: 1.0.5 (27 May 2014) Read the CHANGELOG.

Create rules as JSON object
Create 'WHERE SQL' parsing rules JSON object using Prepared Statements or not (available for php)
Set rules from JSON object
Fully configurable
Support nested filter groups
Restrict operators per filter
Filter types
- text
- number
- date
Supported form elements
- input (text, radio, checkbox). At least one checkbox or radio must be checked (single checkbox interface is not supported at this time).
- select
Supported widgets:
- jquery ui datepicker and timepicker (by Trent Richardson)
- jquery ui autocomplete
- jquery ui slider
- jquery ui spinner (jqueru ui >= 1.9)
Filter default value supported
Filter value validation ('numeric' using jquery $.isNumeric and 'date' using moment.js library)
Filter value conversion using javascript (or server side) function
Localization