Generate selection list based on Object Browse filter...

[CTucker]

Request: It would be nice to have a Object Selection file generated for you based in the current Object Browser filter. This would be useful for the Export User Objects which currently does not filter according to the Object Browser filter. I actually wrote a SQL statement that I could paste into a file and use to filter objects for export. The nice thing is that you can work across schemas - e.g. promoting Objects from DEVELOPMENT to TEST environments based on invalid objects in TEST.

You could add an option for the Export User Objects to refresh based on the Object Browser filter or ignore the filter and show all user Objects.

 

[Marco Kalter]

The Export User Objects tool does indeed not use the Browser Filter (which does not have to be limited to a user). In 5.1.1 you can however save an object selection and reload it later (right-click on selection -> Save/Load Object Selection). If you frequently use the same object selection, this can make life easier.

------------------
Marco Kalter
Allround Automations

 

[CTucker]

I realize that the Object Selection can be saved - what I'm suggesting is that you add a feature to generate out a Object Selection based on the Object Browser filter (restricting it to User owner objects if need be) so that it can be used for Object Selection.

For example - I have a few hundred packages and want to export all invalid packages. Currently you cannot sort on the icon so I have to scroll through all my packages and select only those that are invalid. An easier way would be to set the filter to "My Invalid Objects" and generate out an Object Selection file that I use to quickly select the object I want.

Another example would be - I set up filters against my TEST and PRODUCTION systems and use these filters to determine the code I'd like to migrate from my DEVELOPMENT system.

I had occasion to use the criteria on our TEST system to drive migration from DEVELOPMENT and generated my own Object Selection file to do it and thought that it was very useful - thought generating the Object Selection file was not as straight forward as having a feature to do it for me. Note that the system I'm working on has 256 tables, 490 triggers, and 694 packages (most with bodies), 1000+ synonyms and the Export User Objects list is very big to walk through.

Thanks,

 

[Marco Kalter]

I have added this to the list of enhancement requests. It seems a useful addition.

------------------
Marco Kalter
Allround Automations

 

[vllr]

Found this thread after I suggested generating object selection list from the project items - looks VERY similar! Just add two more right click menu items in "Export user objects":
1. Generate from Object Browser Filter
2. Generate from Project Items
Thanks in advance!!!