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

harshitb6843 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO