Le_or_lhs_null - ObjectVision/GeoDMS GitHub Wiki

Ordering functions less than or equals to or left side has null values

• le_or_lhs_null(a, b)

le_or_lhs_null(a, b) results in a boolean data item indicating if the values of data item a are less than or equals the corresponding values of data item b or if the values of data item a are null.

The comparison with missing values in data item a results in the value True (except for null values in data item b).

Data items with Numeric, string or bool value type

1. Domain of the arguments must match or be void (literals or parameters can be compared to data items of any domain).
2. Arguments must have matching:
   • value type
   • metric

attribute<bool> AltB (CDomain) := le_or_lhs_null(A, B);

CDomain, nr of rows = 10

• less than or equals to (<=)