Introduction
To get started use the controls below or pick one of the pre-defined searches here:
RedQueryBuilder
Please wait
Example usage
SQL
Not set yet
Meta data 
Not loaded yet
Saved searches 
Not loaded yet

What is it?

RedQueryBuilder fills the gap between a hand coded "quick search" and a full blown query language. A typical use is in an intranet web application where experienced users need a quick ad-hoc way to find particular data. This means they don't have to use report frameworks or ask a techie.

To use in your app you just need to drop in the JS, feed it the meta data for your database then handle the change events to get the SQL and argument values.

Download: Javascript - version 0.8.0 zip

JavaScript API docs.

Features include:

  • Pure JavaScript.
  • Can be fed simple meta data (JavaScript/JSON or GWT interfaces)
  • Client side SQL parser so it can load existing SQL (within limits of the UI)
  • Non-GWT integration support with event handlers and JavaScript object configuration. See source of the JDBC sample page.

Source: https://github.com/salk31/RedQueryBuilder

Support: stackoverflow.

Thanks

  • http://code.google.com/webtoolkit/ for making it easy enough even for us to write complex client side code.
  • http://www.h2database.com very easy to use database. Runs happily on my laptop or appengine without changes (memory database).
  • http://jquery.com/ making it easy to glue the samples together.
  • https://bitbucket.org/stanlemon/jgrowl for nice way to show events being fired.
  • http://flexigrid.info/ very easy to use and pretty results table.
  • https://github.com/douglascrockford/JSON-js for JavaScript object serialisation for old browsers.

Similar projects

Contributions

If you have found this code useful then please consider making a donation to fund future development.