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.
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
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
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:
Recordrepresents the record being edited. It is the referencing record.
Referencedrepresents 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.FID_CostCenter = Referenced.FID_CostCenter