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
Found something wrong, missing, or unclear on this page?Raise an issue in our repo.