Few Changes

Now Gsoc coding period starts,here i suggest  few changes in the Design of Visual Query builder.

History

History  will have four main part Object ,Detail,And/Or indicator and Delete

1) Object : This column is for support of self Join operations,in this all operations(where,having,etc..) which belong to same object of table will be stacked together.In the Object column we will have a Drop down-list containing all Object for that particular table and option to add new object.  By default when a new operation is added it will have the same value as that of last used object value for that table.

2) Detail : Will contain detail information about the operation.

3) And/Or Indicator : This will have two options(Green=And,Red=Or) which can be change from on/and by clicking on the and/or(Indicator will change colour on mouse click event), default Colour will be Green(And).

4) Delete : To delete a particular operation tab.

Join Relation

To support self Join operation,select table , select objects and specify details for where condition.

This will add a new entry in History.

example query : to select the id-no’s ,where comp-code of courses having instructorIncharge as “mark” is less than comp-code of courses having Units =3

Select idNo from component ,course c1,course c2 where c2.instructorIncharge=”mark” and c1.unit=3 and c1.compcode>c2.compcodeFor above query we will check idNo in component table,then will add c1 and c2 objects and finally add relation for c1 and c2.by selecting table name as course,object1 as c1 and object2 as c2 and then selecting attribute as Compcode and finally selecting “>” relationship.

Advertisement