Special Cases for Attributes

In certain situations, SemQL clauses support a dedicated syntax to access specific records. For example, to manipulate duplicate pairs and references.

Attributes of Duplicates

Certain SemQL expressions manipulate two similar records simultaneously:

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

  • The SemQL condition used to filter duplicates.

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

The following condition returns the 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 Pickers 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 following condition is set on a reference picker that enables selecting an Account Manager (Employee) from a Customer entity managed in a stepper. It reduces the selectable employee records to only those in the same country as the Customer being edited.

Record.Country =  Referenced.Country

The following condition is set on a reference picker to select the Manager (an instance of Employee) of a given Employee. It filters the selectable managers (Referenced) so that they are in the same CostCenter as the the current manager (Record.Manager).

Record.Manager.FID_CostCenter = Referenced.FID_CostCenter