Partial diff filter question

[pematt]

Hi, thanks for a great product! I have a question regarding how to use the partial filtering.

Objective
I want to do a diff on all objects that are contained in all schemas that have a schema name starting with an underscore. How to do this, please?

Attempts
I tried setting Object to Schema, pattern to _* and Matching to Wildcard. The result is that it is doing a diff on all those schemas but not on any objects contained in those schemas, which is not really what I want.

Alternative
An alternative that would work for me is if the diff did a diff only on the database objects that are in my model while ignoring any database objects present in the database which are not in my model. Is that possible?

Thanks

[rkhaotix]

Hi!

Attempts
I tried setting Object to Schema, pattern to _*, and Matching to Wildcard. The result is that it is doing a diff on all those schemas, but not on any objects contained in those schemas, which is not really what I want.

Instead of using the Object filter as Schema, use Any object. That way, the pattern will match all objects under the schemas. Another tip is to use a pattern like this _*.*, which will match the objects' signatures (the junctions between schema name and object name).

For example, say you have the following objects:

_schema
_schema.table1
_schema.table2
_schema.function(integer, varchar)

The pattern _*.* must list all four objects above.

[mattias-aims]

Thank you very much, that solved it!