Simple SQL Query Builder in JQuery

I am trying to find a simple query builder interface similar to the SQL Query Builder plugin at http://plugins.jquery.com/project/SQL_QUERY_BUILDER, but simpler.

I like it's functionality, but I just want to define the fields, the types, and perhaps some extra information (min and max value) and have a list generated that match the criteria. Simple ANDs and ORs as well.

Example GUI would be something like:

[SELECT BOX (and/or)] | [SELECT BOX (FIELD NAME)] | [SELECT BOX (Comparison)] | VALUE | [BUTTON ADD]

 department = 'SALES'

AND name like '%SMITH%'

Does a plugin like this exist in JQuery or another Javascript Framework?

Thanks!

Matt

10
задан mattjvincent 5 May 2011 в 19:21
поделиться