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 153622 - Add ability to select a subset of the tables to be shown under a connection
Summary: Add ability to select a subset of the tables to be shown under a connection
Status: RESOLVED DUPLICATE of bug 202833
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-21 10:32 UTC by Roman Mostyka
Modified: 2013-05-13 19:04 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-11-21 10:32:53 UTC
Hi, all.  I've been getting feedback from a number of places today that we need to be careful with schemas with a large
number of tables, where users have to wait and wait and wait when they only wanted to work with one table or some small
subset of tables in the overall schema.
What we need is the ability for users to select a *subset* of the tables to be shown under a connection.

Here is what I am thinking:

- The user opens a new connection, and when they open the connection folder for the first time, a dialog comes up asking
if they want to choose all tables or specify a subset through a filter string.

- If the user says 'all', we do what we do today

- The user types in a search string, and all tables matching are displayed.  They select the ones they want and add them
to their master list.  They can repeat as many times as they like

- The user can also select a table or set of tables and choose "add all related tables" and all tables to which the
selected tables are related through foreign key constraints are added.

- The user clicks "OK", and those tables are shown under the connection

- We remember the list so that if the user closes the connection and re-opens it, the same list is shown

- At any time the user can choose an action on the connection to add/remove tables.  They can also right-click on a
table and choose "Add Related Tables" at any time.

What do you think?

David
Comment 1 Roman Mostyka 2008-11-21 10:33:39 UTC
Here's another idea...

I'm not saying your idea isn't the way to go.  But here's another approach:

- The Tables node list uses pagination.  Up to 100 (the number doesn't really matter) at a time will be displayed, and
a paginator widget is used to allow the user to page through the tables.

- A table filter can be applied.  The paginator still applies.

- The filter and current page are stored so that if the connection is restored the table list restores to the same
filter and page.

The big benefit here is that the user can never get caught trying to load large numbers of tables into the explorer
tree, but can easily
get to what they're looking for.

Rob
Comment 2 David Vancouvering 2008-11-21 16:58:16 UTC
Roman, why is this a defect instead of an enhancement?  And what's your justification for P2?  Thanks.
Comment 3 Jiri Rechtacek 2009-10-16 14:04:17 UTC
Reassigned to new owner.
Comment 4 matthias42 2013-05-13 19:04:19 UTC

*** This bug has been marked as a duplicate of bug 202833 ***