How to stored procedure use in interface.

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

Thanks so much . I  solved my problem

Thanks so much . I  solved my problem