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
a!executeStoredProcedureForQuery( dataSource: cons!DS_CONNECTED_SYSTEM, procedureName: "ProcedureName", inputs: { a!storedProcedureInput( name: "IN_ID", value: ri!id ) } )
Harshit Bumb (Appyzie)
How do I set up a cloud database using a!executeStoreProcedureForQuery?
Baby said:How do I set up a cloud database using a!executeStoreProcedureForQuery?
What do you mean by set up a cloud database using a!executeStoreProcedureForQuery?
Konduru Chaitanya
I want to use a!executeStoreProcedureForQuery
but datasource what value do i need to set?
Now i am using cloud database
I would say please go through the documentation for better understanding.
dataSource: "The data source that contains the stored procedure. The value depends on how your data source is connected. For data source connected systems, enter the connected system constant. For data sources connected in the Admin Console, enter the name of the data source or a Text constant that stores the name."
a!executeStoredProcedureForQuery() Function
May I Know which database you are using is it Appian cloud Mariadb, or any other databases
Now i am using appian cloud mariadb
Are you using any other schemas in database other than appian, if not your data source name would "jdbc/Appian", You can save this value in constant and use
Abhishek Karumuru said:jdbc/Appian
I would say add this in a Text constant and call it in the function.
Thanks so much . I solved my problem