Skip to content

Latest commit

 

History

History
executable file
·
60 lines (50 loc) · 3.02 KB

readme.md

File metadata and controls

executable file
·
60 lines (50 loc) · 3.02 KB

Generic 'q' builder Tool

This is a simple HTML / JavaScript application that is used for Building 'q' That can be used with any REST based system.

Generic 'q' builder (Version 1.0)

An interative demo and ZIP download are hosted on gh page http://redquerybuilder.appspot.com/

'q' builder is based on pure Bootstrap and JQuery. Where You can build sql queries as a tree.

Build

  • Download the code put project in any any local server and it will run
  • For Integration with Rest based System you need to write AJAX calls in main.js to fill the pre given object of fields and models
  • To use this plugin go through the scenarios of where clause given below.
  • You can post your comment and issues on git hub issues

Scenarios

Where condition as single group-
  • Single AND Condition eg: (a && b) 55
  • Its Query 56
  • Single OR condition eg: (a || b) 57
  • Its Query 58
Where condition as Two group-
  • Both AND (a && b && (c && d)) 60
  • Its Query 61
  • Both OR eg: (a || b || (c || d)) 62
  • its Query 63
  • First AND and inside it OR as (a && b && (c || d )) 64
  • Its Query 65
  • First OR and inside it AND as (a || b || (c && d)) 66
  • Its Query ( it will create a virtual key to represent as JSON object for c and d 67

Similarly we can design it for three and more groups

Select clause can be designed as-
  • Want to select Single field 70
  • Its Query 71
  • Select Two fields 72
  • Its Query 73
Other clauses can also be designed in the same way from UI.