How to fetch data list from a Stored Procedure in Process without Forms?

Comments

4 comments

  • Hi, 

    you can use stored procedure activity in process model:

    https://documentation.agilepoint.com/00/appbuilder/cloudenvShapeStoredProcedure.html

    For that you can create a complex repeatable node in the process fields and map your repeateable data in Stored procedure to your repeatable node in process fields.

    Regards

    Alexey

    1
    Comment actions Permalink
  • Avatar
    jacsonzhu

    Hi Alexey, thanks for comment,but it seems can't to set mapping in Stored Procedure activity,How to set mapping?

    0
    Comment actions Permalink
  • Avatar
    Loren Bratzler

    I have never tried to use the "Advanced" tab of the Stored Procedure activity.  But using the "Basic" tab is very simple.

     

    You just need to select your database access token, schema, and then select the Stored Procedure you want to run from the drop-down list.  Once you select it, the parameters fill into the grid showing if they are input or output parameters.  Then you can just drag & drop variables from your process schema into the fields.

    0
    Comment actions Permalink
  • Avatar
    Cutting, Victor

    I have the same question. I have a stored procedure that returns a list of user names (say about 10 rows). How do i map that data to a process variable in the schema. There is no option in the Stored Procedure activity to do that. Is it unsupported?

    0
    Comment actions Permalink

Please sign in to leave a comment.