Multiselect in "Select database table" window

Having trouble installing Oxygen? Got a bug to report? Post it all here.
pmonks
Posts: 13
Joined: Fri May 05, 2006 2:10 am

Multiselect in "Select database table" window

Post by pmonks »

G'day,

I'm reverse engineering a relational database that has a reasonably large number of tables, but I can't seem to select more than one table at a time in the "select database table". Would it be possible to add some kind of multi-select functionality?

Some suggestions:
1. allow selection of more than one table at a time via Ctrl+click and Shift+click, then spacebar to toggle the checkboxes on all of the selected tables
2. select all / deselect all buttons per schema / database (so that you can select all tables in one schema / database, but not select any tables in other schemas)

Cheers,
Peter
pmonks
Posts: 13
Joined: Fri May 05, 2006 2:10 am

Post by pmonks »

Another annoyance is that the up and down arrow keys scroll the window containing the list of schemas / tables, rather than moving the selection up and down. AFAIK this means that there is no way to move the selection without using the mouse.
sorin_ristache
Posts: 4141
Joined: Fri Mar 28, 2003 2:12 pm

Post by sorin_ristache »

Hello,

The Select database table (menu Tools -> Convert DB structure to XML Schema) allows you to select more than one table at a time. Just click on the checkboxes in the tree nodes corresponding to the tables for which you want to generate an XML Schema as in the video demonstration. You are right, the arrow keys should move the selection up and down in the tree instead of scrolling the window panel. We will fix the problem.

Regards,
Sorin
pmonks
Posts: 13
Joined: Fri May 05, 2006 2:10 am

Post by pmonks »

G'day Sorin,

I think you misunderstood the problem - it takes one click to check each checkbox, which for a large data model (eg. one with > 100 tables) is painful (particularly since you can't navigate that window using only the keyboard, due to the arrow key problem I mentioned in the followup).

As I mentioned in my original post it would be preferable if it was possible to select a large number of table names in the window, then check them all with a single click / key press. FWIW the Windows standard for these kinds of operations are Ctrl+click to add to the clicked item to the selection (without toggling any associated checkboxes) and Shift+click to add all items between the previous selection and the clicked item to the selection. Try selecting a file in Windows Explorer then Ctrl+clicking or Shift+clicking other files in the same directory to see what I mean.

Cheers,
Peter
sorin_ristache
Posts: 4141
Joined: Fri Mar 28, 2003 2:12 pm

Post by sorin_ristache »

Hello,

I already added an enhancement request on our bugzilla for selecting table names using Ctrl + click and Shift + click.

Thank you,
Sorin
Post Reply