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.

Features

  • 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:
  • 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

Screenshots