Home | Table of Contents | SequenceChecker | CloverETL 4.6.1
--- | --- | ---
Prev | Others | Next

## SequenceChecker

# Not available in Community Designer

Short Description
Ports
Metadata
SequenceChecker Attributes
See also

### Short Description

SequenceChecker checks the sort order of input data records.

Component | Same input metadata | Sorted inputs | Inputs | Outputs | Each to all outputs [1] | Java | CTL | Auto-propagated metadata
--- | --- | --- | --- | --- | --- | --- | --- | ---
SequenceChecker | - |  | 1 | 1-n |  |  |  |
[1] Component sends each data record to all connected output ports.

### Icon

### Ports

Port type | Number | Required | Description | Metadata
--- | --- | --- | --- | ---
Input | 0 |  | For input data records | Any
Output | 0-n |  | For checked and copied data records | Input 0 [1]
[1] If data records are sorted properly, they can be sent to the connected output port(s).

### Metadata

All metadata must be the same.

Metadata can be propagated through this component.

### SequenceChecker Attributes

Attribute | Req | Description | Possible values
--- | --- | --- | ---
Basic
Sort key | yes | Key according to which the records should be sorted. If they are sorted in any other way, graph fails. See Sort Key for more information. |
Unique keys |  | By default, values of Sort key should be unique. If set to `false`, values of Sort key can be duplicated. | true (default) | false
Equal NULL |  | By default, records with null values of fields are considered to be equal. If set to `false`, nulls are considered to be different. | true (default) | false
Deprecated
Sort order |  | Order of sorting (`Ascending` or `Descending`). Can be denoted by the first letter (`A` or `D`) only. The same for all key fields. Default sort order is ascending. If records are not sorted this way, graph fails. | Ascending (default) | Descending
Locale |  | Locale to be used when internationalization is set to `true`. By default, system value is used unless value of Locale specified in the `defaultProperties` file is uncommented and set to the desired Locale. For more information on how Locale may be changed in the `defaultProperties` see Chapter 18, Engine Configuration. | system value or specified default value (default) | other locale
Use internationalization |  | By default, no internationalization is used. If set to `true`, sorting according national properties is performed. | false (default) | true

### Details

SequenceChecker receives data records through single input port, checks their sort order. If this does not correspond to the specified Sort key, graph fails. If the sort order corresponds to the specified, data records can optionally be sent to all connected output port(s).

### See also

Common Properties of Components
Specific Attribute Types
Others Comparison

Prev | Up | Next
RunGraph | Home | Table of Contents | SystemExecute