bbartlett
Canvas Initiate

SQL request stored procedure parameter

Is it possible to base a SQL Store Procedure parameter off of another SQL request drop down selection on the same form? 

I have one field 'Pay Location'' that is a SQL request drop down. Once a value is selected I am hoping to use this value for a @PayLocation parameter located in another stored procedure that is being used on another SQL request drop down that will then show all Employees who's pay location = @PayLocation. 

Attached is a screenshot of the configured parameter for the stored procedure. 

Tags (1)
Reply
1 Reply
fhunth
Workflow Veteran

Re: SQL request stored procedure parameter

Have you solved it?

0 Kudos
Reply