Data filtering

The list of batches (ICLs) that are displayed can be filtered by using the filter functions. To filter the batch (ICL) list, first select a business day. The default for the business day filter is the most recent business date in the format yyyy–mm–dd.

After a business day is identified, use the Filter field to choose a particular column to filter. To display the unfiltered list, click the X to remove the filter, then click Go. The filter supports filter chaining, allowing more filters for each column to be added by clicking the +.

The following table shows the columns that are available for filtering.
Table 1. Available columns for filtering for batches (ICLs)
Filter Operator types Search term examples
Bank Numeric 5
Endpoint / Sidepoint String 12345678
Batch / ICL type Static Select from a list of valid batch / ICL types
Control credit amount Numeric 127000 or 127000.50
Note: The filtering on financial data does not support the grouping delimiters, such as commas.
Control debit amount Numeric 127000 or 127000.50
Note: The filtering on financial data does not support the grouping delimiters, such as commas.
Credits Numeric 100
Debits Numeric 250
Status Static Select from a list of status conditions
MCRE Extracted Static Select whether the MCRE extract occurred.
  • not extracted
  • extracted
Distribution Type Static Select from a list of valid distribution types
Auxiliary Extract 1 Static Select whether the auxiliary extract 1 occurred.
  • not extracted
  • extracted

The filter supports filter chaining based on available columns and values. The operators and or or can be used to chain multiple filters. By default, the and operator is used when another filter is created. Only one column can be used for each specific filter query, but multiple queries can be chained together, enabling filtering across multiple columns.

Table 2. Columns for extended filtering
Filter Operator type Search term
Settlement date Static
  1. Choose the appropriate date operator.
  2. Select the date that you want based on the operator that you chose.
  3. The Settlement Date appears as an option only when the Settlement Date column is selected in the user preferences.
  4. Select the checkbox next to the Settlement Date filter to activate it.
  5. Clear the Settlement Date filter checkbox to deactivate the filter when needed.