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 |
Last Updated: 20 June, 2023