Compound Filter Properties Window

Filter Name

Enter a name for the new compound filter.

Comment

Enter a description for the filter.

Available filters

Lists all of the filters available for inclusion in the compound filter. This list shows all defined filters except: filters that already appear in the Component Filters list; filters that refer directly or indirectly to the filter being edited (to prevent making a circular reference); filters that have a row count limit. Note: While compound filters do support a "Row Count Limit", i.e., first n rows, it should be noted that while a compound filter may itself have a row limit, none of its component filters may have a row limit.) Tip: If you use the mouse to hover over a filter, a tooltip appears, listing the filter expression. If the expression is very long, the tooltip will show as much text as possible and end with an ellipsis.

Names on the "Available filters" list are sorted alphabetically. Double-clicking on a name moves that filter to the "Component filters" list. Names may also be moved to the "Component filters" list using the Add button. The "Available filters" list supports multiple selection so a user can move several filters at once. Tip: If you use the mouse to hover over a filter, a tooltip appears, listing the filter expression. If the expression is very long, the tooltip will show as much text as possible and end with an ellipsis.

Clear

Removes all filters from the Component Filters list and returns them to the Available Filters list.

Add>>

Click to add the selected filter(s) to the Component Filters list. Doing so removes the filter(s) from the Available Filters list.

<<Remove

Click to remove the selected filter(s) from the Component Filters list. Doing so returns the filter(s) to the Available Filters list.

Component filters

Lists all the filters that are components of the compound filter.

The Component filters list shows the filters that are components of this compound filter. Components may be either formula-based or compound filters. Since their order is irrelevant, they are always sorted alphabetically. A filter icon is shown to the right of each filter in the components list. This icon appears with a red circle and slash if the filter is being used in its inverse sense (i.e., the NOT of the filter). Double-clicking on a name in the "Component filters" list changes its sense from normal to inverse or vice versa. One may also change the sense of a filter by right-clicking on it and choosing the appropriate entry from the context menu.

Select rows that satisfy options:

Filters in the Component Filters list are combined using either Boolean AND logic or OR logic. To specify the desired logic with which to combine the component filters, select one of the following two options:

• Select rows that satisfy options: Specifies that the filters in the Component Filters list are combined using AND logic (i.e., only records that satisfy all the filters will be displayed).

• Any one of the component filters: Specifies that the filters in the Component Filters list are combined using OR logic (i.e., all records that satisfy any of the component filters will be displayed).

Component  filter expression

Displays the filter expression for the current compound filter.

Row Count Limit

These options are provided to allow you to place an absolute limit on the number of records available to the table window. You can use this feature to perform auditing, where you might want to work with only a sample of the available data, or you might use this feature when defining summaries and calculated fields (by limiting the amount of data, Monarch Classic will build calculated fields and summaries faster). After you complete your summary or calculated field definitions, you can remove the limit to work with all data.

No limit

Use this setting to return all records that pass the filter expression.

First n Rows

Use this setting to limit the number of records returned by the filter. Monarch Classic first applies the filter expressions to all records, then the table is sorted (if a sort definition is active), then the table is truncated to the number of records you specify. If the filter returns fewer records than you specified, this option has no effect. You may specify a number in the range 1 – 150000.