Bug #1595
closedCreate Advance Query Builder UI
0%
Description
Create a UI to enabled a user to specifiy a query for an access actor (Query
Builder)
The QB will take as input:
1) Nothing
2) A kepler\src\org\ecoinformatics\seek\datasource object
The ouput:
A composite query object representing the query (with joins and where clause)
Rough Sketch:
The UI contain two panes:
1) The upper pane
a) Shows all the tables defined in the database.
b) The user will be able to D&D fields from one table to another to define
foreign keys and/or table joins.
2) The lower pane will contain a tab control with two tabs
a) The less advanced tab will enable a user to enter the defeinition of a
where clause and all the items and their conditions will be grouped
by either an "and" or an "or". The text will read "Must meet all of
the conditions" or "Must meet at least one of the conditions"
b) The advanced tab will enable a a user specify a much more complex,
nested version of "ands" and "ors" This UI will look very close to the
the Query Builder UI for the Ecogrid (See below)
Description of UI for Advanced UI of the lower tab:
<AND>
<the condition goes here>
<OR>
<another condition goes here>
<another condition goes here>
</OR>
</AND>