This topic provides information about datatype default values that can be set for mobile business object (MBO) attributes and parameters.
select ... from my_table t where t.last_modified >= ... and t.x >= :XIf X is NULL, no rows are returned, since (t.x >= :X) is false in the database if X is NULL.
SAP attribute and parameter datatypes do not support NULL as a default value. If the data source is SAP and no default value is specified, the default value is an empty string.
select * from my_date where (dateformat(c2,'yyyy-mm-dd') = dateformat('@OP[''Date''='''']', 'yyyy-mm-dd')) OR (c2 IS NULL AND '@OP[''Date''='''']' IS NULL)