This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 94062 - Query criteria - AND and OR operators not implemented.
Summary: Query criteria - AND and OR operators not implemented.
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P2 blocker (vote)
Assignee: John Baker
Depends on:
Reported: 2007-02-02 20:04 UTC by bugbridge
Modified: 2008-02-27 07:46 UTC (History)
1 user (show)

See Also:
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description bugbridge 2007-02-02 20:04:14 UTC
    The reason why this rfe has higest priority is following: real-life 
queries very often combines several search conditions. Lack
of AND/OR functionality in the querybuilder would often force users to create 
or update queries manually instead of using grid pane
or diagram pane. At present (build 040202) it is only possible to specify 
complex search condition by editing SQL instead of typing
it into the grid pane. It is not possible even to change simple search 
condition without editing SQL (see bugs listed in the 'see
also' section). Since grid pane GUI is designed in order to support OR 
functionality, the fact that it is unsupported may be also
confusing for the user.

    Functionality that should be implemented (see also referenced bug id's):

    Use case: Apply multiple search conditions to the same data column.
    Input: In the Grid pane, user adds the column to search. In the 'Criteria' 
column for the data column just added, user specifies
the first condition. In the 'Or...' column for the same data column, user 
specifies the second condition.
    Result: SELECT fname, lname FROM employees WHERE (salary < 30000) OR 
(salary > 100000)

    Use case: Include several data columns as part of the search condition for 
a query.
    Input: In the Grid pane, user adds several columns to search. In 
the 'Criteria' column for each data column added, user
specifies condition.
    Result: SELECT pub_id, title FROM titles WHERE (pub_id = '0877') AND 
(title = 'Cook')

    Precedence of AND and OR operators should be maintained correctly.

Will be implemented in future releases.