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.

Stored Procedure Query

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.