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