Differences Filters are used to show differences that match some specific criteria. In other words, to discard the differences which doesn’t match these criteria.
This can be used, for instance, to show only differences where the Field is Required in the Receiving Application but Optional (or Missing) in the Sending Application.
- Click the [empty] filter button within the section for which you want to filter differences. A filter dialog will be shown.
- Click the Add… button to add a new filter.
- Edit filter settings.
- Click the OK button when you’re done editing your filters. The filters will be applied, showing only differences which match your criteria.
|Source:||Select the side from which you want to perform a filter.|
|Column:||Select the column from which you want to get the value to be compared.|
|Is/Is Not:||Include/Exclude differences that match the filter.|
|Operator:||Select the operator that you want the criteria and the column’s value to match.|
|Criteria:||Enter the criteria that you want to compare with the column’s value.|
|Checkbox:||Activate or deactivate filter (toggle on or off).|
AND: applies both these filters.
OR: applies either of these filters.
|Parentheses:||Used for nested filters.|
|=||Covers values with an exact match to this data (this is like putting quotation marks around a search engine query)|
|>||Greater than. Covers filtering on numeric values.|
|>=||Greater than or equal to. Covers filtering on numeric values.|
|<||Less than. Covers filtering on numeric values.|
|<=||Less than or equal to. Covers filtering on numeric values.|
|containing||Covers messages that include this value.|
|present||Looks for the presence of a particular column.|
|empty||Looks for an unpopulated column.|
|matching regex||Use .NET regular expression syntax to build filters. For advanced users with programming backgrounds. Learn more about regular expressions here:|
|in||Builds a filter on multiple data values rather than just one value.|
|= Other Specification Value||Exact match to the other profile’s column value.|
|> Other Specification Value||Greater than the other profile’s column value. Covers filtering on numeric values.|
|>= Other Specification Value||Greater than or equal to the other profile’s column value. Covers filtering on numeric values.|
|< Other Specification Value||Less than the other profile’s column value. Covers filtering on numeric values.|
|<= Other Specification Value||Less than or equal to the other profile’s column value. Covers filtering on numeric values.|
While editing your filters, you can switch between Basic and Advanced Mode. Advanced Mode shows advanced settings for your filters. These settings help in the construction of more complex filters using AND/OR operators and parentheses for nesting. Otherwise, each filter will be applied one after the other.
If your filters contain advanced settings and you switch back to the Basic Mode, these settings will be lost.
Differences Filter Template
Differences Filters Template are re-usable filters that can be applied to many Gap Analysis. A built-in can be selected from the drop-down list at the top-left of the filters dialog.
Hide a Difference from the Gap Analysis Result section
You can hide a difference (Gap Analysis Result row) automatically. To do so, right-click the row you want to hide, then click “Hide [row key] difference”. This adds a new difference filter entry and hide the selected row.