You are viewing limited content. For full access, please sign in.

Question

Question

Custom Query to return Output parameter

Workflow
Updated April 16, 2020
asked on April 10, 2020

I have a custom query like below that returns an output parameter. How do I get the value of that output in my workflow?

 

  declare @hierrarchyListing1 varchar(100)
   exec [Get_HierarchyLevel]  'ABC',11111,@hierrarchyListing1 OUTPUT

 

Thanks

Priya

0 0

Replies

replied on April 13, 2020

Any update on this please

0 0
replied on April 14, 2020 • Show version history

Hi Priya

It would be common to use a For Each Row with a Query or Custom Query to process through the results of the Query. The Activity would connect to the Query Results as shown below

Your return variables would then be displayed in the For Each Row Activity

0 0
replied on April 16, 2020

Thanks

0 0
replied on April 16, 2020

It is not working. In my for each, I do not see @hierrarchyListing1 

0 0
replied on April 16, 2020

Can you drop in a picture of this part of your workflow, the Custom Query Activity. Is your connection to the DB SQL direct or ODBC?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...