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.StoredProcedureobject. This object is then passed through the data source to the service provider for processing.
The following will execute a stored procedure called
spGetUsersin 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")
Visit the data source service provider documentation for details on support for stored procedure queries.