Page 1 of 1

Multiselect in "Select database table" window

Posted: Fri May 05, 2006 8:12 pm
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

Posted: Fri May 05, 2006 8:15 pm
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.

Posted: Mon May 08, 2006 11:49 am
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

Posted: Mon May 08, 2006 6:20 pm
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

Posted: Tue May 09, 2006 9:21 am
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