How to stored procedure use in interface.

Certified Associate Developer

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

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data