Filter objects by user custom text filter
I have multiple different objects between schema and i nedd to compare only onjects (filter objects) that corespond to a more complex criteria (not just by name). I would filter for example by creation date (in a certain interval), object type, eventually the name, and other custom criteria.
It would be very nice that in the project properties (or near the filter by name) user could have an edit box to edit the custom criteria.
For example, criteria could look like:
(objectname like 'TR%' or objectname like '%BN') and objecttype in ('VIEW', 'TABLE') and createddate>sysdate-3)
The list of coulumn names should be listed in help in orde to be used in the internal select of SOCO.
-
Bernhard Schwarz commented
I have additional unit test objects in my schema, which I would like to exclude from comparison in general. They should easily be excluded by name pattern.