iTwin.js Types used in ECSQL Parameter Bindings

The following table list which iTwin.js type you can use for binding values to ECSQL parameters.

ECSQL Parameter Type iTwin.js Type
Boolean boolean
Blob Uint8Array
DateTime ISO 8601 date time string
Double number
GUID GuidString
Id Id64String
Integer number. Use a decimal string, if the value is greater than the JavaScript limitation for big integers.
Navigation Value NavigationBindingValue
Point2d XAndY
Point3d XAndY
Range3d LowAndHighXYZ
string string
Struct JavaScript object matching the members of the struct. The member values can be primitives, arrays, or objects of the above types
Array JavaScript array of primitives or objects of the above types

Looking for how to use this in with the iTwin API? See ECSQL Binding Code Examples.
Looking for how different parameter types handle null update cases? See ECSQL Null Behaviors

Last Updated: 08 August, 2024