Comparing Snapshots - Using the Filter Options

Top  Previous  Next

 

lightbulb_on

Snapshot Compare allows the use of filters to make it easier for the user to find the exact differences they are searching for.

 

Filtering Options

 

There are two subsets of filtering options. Both can be used before and after a snapshot is compared.

First, you have the option of filtering items by status.

 

Checking and unchecking the above status checkboxes will cause the snapshot results to either show or hide items in the respective status. For instance, the snapshot image below shows that uspUpdateEmployeePersonalInfo has been modified in "aw snapshot 4".



After the "Modified" checkbox is unchecked uspUpdateEmployeePersonalInfo no longer appears in the results view.

 

Re-checking the "Modified" checkbox will make uspUpdateEmployeePersonalInfo reappear.

 

Filtering Statuses

 

There are five statuses that can be used to filter items in the snapshot compare.

 

 Modified    The object has been modified in on of the snapshots. The icon in the middle of the object name explains which object changed.  indicates the object changed in Snapshot 2.   indicates the object changed in Snapshot 1
 New  The object is new in Snapshot 2. Also indicated by the  icon
 Deleted  The object existed in Snapshot 1, but not Snapshot 2. Also indicated by the  icon
 Not Equal  The object changed from Snapshot 1 to Snapshot 2
 Equal  The objects are the same

 

Object Filters


Snapshot compare allows the use of object filters to filter out types of objects before and after a snapshot. To filter out an object simply uncheck the checkbox next to an object name. When an object is unchecked it will appear in bold red text to indicate the filter has been set.

 

Checking / unchecking an object with child objects will check/uncheck all of its child nodes as well. Below, "SQL Server" was unchecked and all of the child items were unchecked.

 

Pre-Comparison Object Filtering

Using an object filter before a snapshot is performed prevents the snapshot from comparing the filtered objects. If there are object types you do not want to be compared then uncheck the objects before peforming a snapshot compare. This is useful if the snapshot contains objects that will take a large amount of time to be compared when the comparison of those objects is unecessary.

Post-Comparison Object Filtering

Using an object filter after a snapshot is performed simply hides in the results view. For instance in the screenshots below the stored procedures are visible in the first screenshot but not visible after the stored procedure filter option is unchecked.

Stored Procedures are visible


Stored Procedures are hidden