Comment on page
Stored Procedures
Stored procedures are stored in a relational database. A stored procedure query is created by chaining methods together from the root of
wire.data.procedure
. These methods populate the properties of a wire.data.StoredProcedure
object. This object is then passed through the data source to the service provider for processing.To check for service provider support for stored procedures, use the
allow.storedProcedure
attribute on the DataSource object servicing the query request. The following will execute a stored procedure called
spGetUsers
in the database and return the results to the data source.const query = wire.data.procedure("spGetUsers");
The following adds two parameters to the stored procedure query.
const query = wire.data.procedure("spGetUsers")
.param("Active", true)
.param("Domain", "usa.domain");
Visit the data source service provider documentation for details on support for stored procedure queries.
Last modified 2yr ago