data elements to entity definitions window default selection

Posts   
 
    
sapul
User
Posts: 49
Joined: 11-Jan-2019
# Posted on: 14-Jun-2019 10:05:55   

Hi In my db catalog, there are tens of ORACLE objects that should exists but also i will not genarate
entity. ( Materialized Views, ADMIN TABLES, TEMP TABLE)

These objects are listed "selected". Each time, It takes a lot of time to deselect them first and select the table that I just added to Database.

Alternate 1) As in the old design, is there an option that "not mapped" group is listed with no selection.

Alternate 2) do I have a chance to "ignore" objects that I will never do entity defition and send to another list?

Alternate 3) Select NONE button for all items (both mapped and not mapped)

Attachments
Filename File size Added on Approval
data elements to entity definitions.PNG 62,807 14-Jun-2019 10:06.10 Approved
Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 14-Jun-2019 10:46:49   

You can select all unmapped entity rows (select the first and use Shift+DownArrow Keys), then press on the "Toggle Checkboxes..." button.

sapul
User
Posts: 49
Joined: 11-Jan-2019
# Posted on: 14-Jun-2019 10:58:01   

Of course I can. However, since there are dozens of lines to deselect, doing this every time reduces productivity and makes the process vulnerable. I am looking for elegant and fast solution.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 14-Jun-2019 14:41:10   

If you don't have elements mapped on them, you can exclude them from the schema in the catalog explorer: select them all in one go (shift/ctrl-drag) then right click and select 'exclude from catalog'. This will remove them from the project. Next time you refresh the catalog, they're not pre-checked, so you can then just check the table you want to add.

Would that work? If not, please let us know why, so we can think of something else.

In v5.6 we've implemented a filtering / search in this UI as well to narrow down the list so you can easily select them in the UI, but other than that, the main design is based on: if you won't map an element onto a table, just remove it from the catalog in the project.

Frans Bouma | Lead developer LLBLGen Pro
sapul
User
Posts: 49
Joined: 11-Jan-2019
# Posted on: 14-Jun-2019 15:38:21   

If you don't have elements mapped on them, you can exclude them from the schema in the catalog explorer: select them all in one go (shift/ctrl-drag) then right click and select 'exclude from catalog'. This will remove them from the project. Next time you refresh the catalog, they're not pre-checked, so you can then just check the table you want to add.

Once the catalog maintenance is done, the selection process will only be for newly added tables.

it is a very reasonable solution.

Thank you 👍