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

Follow

jacsonzhu

• July 11, 2020 04:04

I want to fetch data list from a Stored Procedure in Process without Forms, How to exec Stored Procedure and map data to Model Data?

0

• 

  Alexey Shmelkin (sysberry-absc.com)

  • July 11, 2020 11:17

  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
• 

  jacsonzhu

  • July 11, 2020 16:08

  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
• 

  Loren Bratzler

  • July 15, 2020 20:00

  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
• 

  Cutting, Victor

  • August 18, 2020 16:08

  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.