Dynamic Parameter

SeekingSolution
New Contributor II

I have a query I need to run with two parameters: Workflow and workflow steps. The dropdown list supplied by "Steps" should change based on the input of the "Workflow" dropdown.

When I use the following code, it creates the "Steps" dropdown list based on the "Workflow" value that is selected in the parameter at that time. And then the list will not change from there. Is it possible to configure the "Steps" parameter to consistently change the dropdown values as selections for "Workflow" change?

current code:

CREATE WIDGET DROPDOWN Step DEFAULT 'All' CHOICES SELECT stepname from reference.workflowsteps where workflowname in(:Workflow)