wire.data.StoredProcedure
Parameter Class
Property | Type | Description |
EventName | string | Parameter name alias used to map a parameter to another parameter or field in another query |
Name | string | Parameter name |
Value | string | number | Parameter value |
Properties
Name | Type | Default | Description |
Name | object | null | The name of the stored procedure in the data service. |
Params | [ ] | null | An array of parameters for the stored procedure. |
Methods
Name | Description |
cast | Static method that casts an object with the same stored procedure properties into an instance of the |
eventName | Adds an event name to a parameter |
getParam(param) | Returns the parameter object named |
param(param, value) | Adds a value to a parameter using the chained method |
If a service provider supports executing stored procedures, it will set the allow.storedProcedure attribute to true
.
The following creates a new StoredProcedure
object which will call the stored procedure spGetUsers
in the data service with a parameter User
equal to apeters
.
The following gets the stored procedure parameter object UserName
.
The following is a TypeScript example that executes the stored procedure in the data service.
Visit Creating Queries - Stored Procedures for more details and examples.
Last updated