Project

General

Profile

Bug #1595

Create Advance Query Builder UI

Added by Rod Spears about 15 years ago. Updated almost 15 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Rod Spears
Category:
actors
Target version:
Start date:
06/08/2004
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1595

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>

History

#1 Updated by Rod Spears almost 15 years ago

Code checked in by Jing

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 1595

Also available in: Atom PDF