Special cases for attributes

In certain situations, SemQL clauses support a dedicated syntax to access specific records (e.g., to manipulate duplicate pairs and references).

Attributes of duplicate records

Certain SemQL expressions manipulate two similar records simultaneously:

  • The SemQL condition that defines the match rule in a matcher.

  • The SemQL condition that is used for filtering duplicates.

For these expressions, the two similar records are identified by the RECORD1 and RECORD2 pseudo-record prefixes.

Return duplicates with the same InputAddress.Address (complex type), but a different CustomerName
Record1.CustomerName <> Record2.CustomerName
and Record1.InputAddress.Address = Record2.InputAddress.Address

Attributes in reference picker filters

In steppers, SemQL conditions can filter the records selectable with reference pickers. These conditions usually manipulate two different records.

In this context, the records are identified using pseudo-record prefixes:

  • Record represents the record being edited. It is the referencing record.

  • Referenced represents the selectable referenced record (the one filtered in the reference picker).

The examples below illustrate conditions set on a reference picker.

Select an account manager (Employee) from a Customer entity managed in a stepper
Record.Country = Referenced.Country

This condition reduces the selectable employee records to only those in the same country as the Customer being edited.

Select the manager (i.e., an instance of Employee) of a given employee
Record.Manager.FID_CostCenter = Referenced.FID_CostCenter

This condition filters the selectable managers (Referenced) so that they are in the same CostCenter as the current manager (Record.Manager).