[kepler-dev] [Bug 1595] New: - Advance Query Builder UI

bugzilla-daemon@ecoinformatics.org bugzilla-daemon at ecoinformatics.org
Tue Jun 8 04:56:05 PDT 2004


http://bugzilla.ecoinformatics.org/show_bug.cgi?id=1595

           Summary: Advance Query Builder UI
           Product: Kepler
           Version: 1.0.0alpha1
          Platform: Other
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P1
         Component: actors
        AssignedTo: rods at ku.edu
        ReportedBy: rods at ku.edu
         QAContact: kepler-dev at ecoinformatics.org


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>



More information about the Kepler-dev mailing list