Differences Filters

Home » Differences Filters

Differences Filters

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.

Add Filters

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.

If a section contains active filters, the filter button will be shown as a full filter .

Filter Settings

Basic Settings

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.

Advanced Settings

Checkbox:

Activate or deactivate filter (toggle on or off).

And/Or:

AND: applies both these filters.

OR: applies either of these filters.

Parentheses:

Used for nested filters.

Operators

=	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: http://www.codeproject.com/KB/dotnet/regextutorial.aspx http://www.regular-expressions.info/tutorial.html
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.

Basic/Advanced Mode

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.

Differences Filters