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

关注

jacsonzhu

• 2020年07月11日 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

• 

  sysberry GmbH

  • 2020年07月11日 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

  评论操作 固定链接
• 

  jacsonzhu

  • 2020年07月11日 16:08

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

  

  0

  评论操作 固定链接
• 

  Loren Bratzler

  • 2020年07月15日 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

  评论操作 固定链接
• 

  Cutting, Victor

  • 2020年08月18日 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

  评论操作 固定链接

请先登录再写评论。