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

1C:Enterprise Developer's Community