Filtering and sorting differences in the compare editor

When you are comparing and merging data objects in the compare editor, you can filter and sort the differences.
About this task

Filter differences in the compare editor to simplify the view. Objects that are filtered from the comparison do not appear in the compare editor.

Sort differences in the compare editor to simplify the display of objects in the editor and to make it easier to find objects with differences.

Restriction:
  • Exported changes are not affected by filtering or sorting. That is, all changes are exported even if you have filtered them from the editor. Sort order is not maintained in the export file.
  • Synchronization or merging is not affected by filtering. That is, delta DDL is generated for all objects, regardless of whether they are filtered from the editor view.

This feature is available only when you compare data objects.

To filter and sort differences in the compare editor:

  1. In the compare editor, click Filter Configuration Filter Configuration toolbar button icon from the compare editor toolbar.
  2. Select filtering options to remove objects from the comparison that you do not want included. For example, you can select to filter primary keys out of the comparison.
  3. Select sorting options. For example, you can select to sort the differences in the compare editor in ascending or descending order.
Results
The differences between the data objects that are shown in the compare editor are filtered or sorted based on the selections that you made.

Feedback