Comparison Operations
Equal
Not Equal
Less
Greater
Less or Equal
Greater or Equal
IN
Operation to Check Value Presence in Data Set
Operation to Check if Value Is NULL
Operation To Check if Value Is Not Equal to NULL
Equal
This operation is intended to compare two operands and find out if they are equal. Example:
Sales.Contractor = Sales.NomenclatureMainSupplier
Not Equal
This operation is intended to compare two operands for inequality. Example:
Sales.Contractor <> Sales.NomenclatureMainSupplier
Less
This operation is intended to check that the first operand is less than the second. Example:
CurrentSales.Total < PreviousSales.Total
Greater
This operation is intended to check that the first operand is greater than the second. Example:
CurrentSales.Total > PreviousSales.Total
Less or Equal
This operation is intended to check that the first operand is less than or equal to the second. Example:
CurrentSales.Total < = PreviousSales.Total
Greater or Equal
This operation is intended to check that the first operand is greater than or equal to the second. Example:
CurrentSales.Total > = PreviousSales.Total
IN
This operation is intended to check presence of a value in the transferred list of values. The operation returns True if the value is found or False otherwise. Example:
Products IN (&Product1, &Product2)
Operation to Check Value Presence in Data Set
The operation is intended to check value presence in the specified data set. The data set for checking must contain one field. Example:
Sales.Contractor IN Contractors
Operation to Check if Value Is NULL
This operation returns True if the value is NULL. Example:
Sales.Contractor IS NULL
Operation To Check if Value Is Not Equal to NULL
This operation returns True if the value is not NULL. Example:
Sales.Contractor IS NOT NULL
See also:
Data Composition System Expression Language
Bilingual Presentation of Data Composition System Keywords