ECSQL null behavior documentation
Setting of a property to null
A value can be directly changed to be null - not contain a value at all. This can be applied for each editable ECSQL parameter type.
Documentation schema sample:
<ECSchema schemaName="NullBehaviorDocs" version="01.00.00" xmlns="http://www.bentley.com/schemas/Bentley.ECXML.3.2">
<ECSchemaReference name="BisCore" version="01.00.04" alias="bis"/>
<ECSchemaReference name="CoreCustomAttributes" version="01.00.03" alias="CoreCA"/>
<ECEntityClass typeName="DocsElement" modifier="None">
<ECProperty propertyName="intProp" typeName="int"/>
<ECArrayProperty propertyName="arrBoolProp" typeName="boolean" minOccurs="0" maxOccurs="unbounded"/>
<ECStructProperty propertyName="structProp" typeName="StructType"/>
<ECStructArrayProperty propertyName="arrStructProp" typeName="StructType" minOccurs="0" maxOccurs="unbounded"/>
</ECEntityClass>
<ECStructClass typeName="StructType" modifier="None">
<ECProperty propertyName="doubleProp" typeName="double"/>
<ECProperty propertyName="stringProp" typeName="string"/>
</ECStructClass>
</ECSchema>
Attempting to update any of the properties (intProp
, arrBoolProp
, structProp
or arrStructProp
, as well as structProp.doubleProp
and structProp.stringProp
) to null should clear the current value of the respective property.
Setting some complex property children to null
To be added
Setting all complex property children to null or making it empty
To be added
Last Updated: 08 August, 2024
Found something wrong, missing, or unclear on this page?Raise an issue in our repo.