ignoreViews Section

Dovetail SchemaEditor allows for certain views in the database to be ignored.

This is useful when you are making a schema change, but there is a view that is in some way "problematic". If the current operation does not involve the problematic view, then we can explicitly define this as a view to be ignored.

A "problematic" view is one that Dovetail SchemaEditor cannot fully resolve. For example, a view may have a view column that references a non-existent column on a table. Or have a join that references a non-existent relation. Or have duplicate aliases defined.

Example of Dovetail SchemaEditor errors that indicate there is a problematic view:

• The join being added has an alias which is already being used by another join on the view for a different table.
• Cannot add Join to View as it already belongs to View
• A Join with the same key is already in the View
• A ViewColumn with the same order is already in the View
• A ViewColumn with the same name is already in the View

The correct way to deal with this issue is to fix the view in question so that it is correct, and can be fully resolved by Dovetail SchemaEditor. However, this may be time consuming and difficult, especially if the current schema change being performed has nothing to do with this particular view. So, we can simply ignore this view for the moment.

To ignore a view, add an ignoreViews section to the .SchemaEditor file.

Then, add one (or more) view elements to the ignoreViews section.

ignoreViews section parameters

Note: ignoreViews can contain multiple view Objects.

Example:

<ignoreViews>

	<view name="bad_view_name"></view>

	<view name="another_bad_view_name"></view>

</ignoreViews>

Did this topic help you? Email us your feedback.
Last updated: 6/6/2011 4:54:00 PM
© by Dovetail Software, Inc.