iModel.js Types used in ECSQL Parameter Bindings

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

ECSQL Parameter Type iModel.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

Last Updated: 13 October, 2019