How to stored procedure use in interface.

Question

Hi Experts, 
 I have create one stored Procedure in DB . Which have two IN Parameters (StartDate , EndDate). 
 How to use procedure to receive data in the interface and how to pass these IN parameters? 
 a!localVariables(
 local!orderCountData:(
 a!executeStoredProcedureOnSave(
 dataSource: "CDM2 Primary Database(Connected System)",
 procedureName:"SP_OrderTypeCount",
 inputs: {
 a!storedProcedureInput(name: "StartDate", value:""),
 a!storedProcedureInput(name: "EndDate", value: ""),
 },
 timeout: 30,
 onSuccess: {
 
 },
 )),
 local!orderCountData
) 
 
 Thanks

Harshit Bumb (Appyzie) · Answer

a!executeStoredProcedureForQuery(
 dataSource: cons!DS_CONNECTED_SYSTEM,
 procedureName: "ProcedureName",
 inputs: {
 a!storedProcedureInput(
 name: "IN_ID",
 value: ri!id
 )
 }
)

How to stored procedure use in interface.

Top Replies