Get value from List Box as argument for subworkflow for Drop Down List

Jesse Langdon

15 février 2025 22:43

I have a form with multiple inputs that will query a non-spatial MS SQL database. In the form, I have an List Box (Select the permit subtype), that once the selection is changed, should run a subworkflow that should populate s Drop Down List (Select folder type) using another non-spatial query that is run.

In the subworfklow, I'm using a Get Form Element Value activity to try to extract the value selected in the List Box, but I can't seem to find the right syntax. 

The List Box's ID is “permitSubtypeValue”, so I thought I could just get the selected value by using =$permitSubtypeValue.value.items[0] or =$permitSubtypeValue.result in the Element input of the Get Form Element Values activity, but that doesn't seem to work:

Cannot read properties of undefined (reading 'value')"

Cannot read properties of undefined (reading 'result')

Ultimately I want to send the selected value from the permitSubtypeValue List Box to the server workflow that runs the SQL query, with the results populating the Drop Down List. Am I just going about this the wrong way? The VertiGIS Workflow documentation is pretty “terse”, so it's hard to find the correct methodology there.

Any help would be appreciated!

0

• 

  Gareth Finney

  17 février 2025 00:44 Modifié

  Hi Jesse.

  I've never really used the Get Form Element  activity, and not sure why your options would not work with that -but I generally just get the value of a drop down list by including the form part itself

  =$mainObsForm.state.dropDownList.value

  0
• 

  Jesse Langdon

  17 février 2025 20:48 Modifié

  Thanks for the response Gareth. 

  I revised my input to the subworkflow to pull directly from the form itself:

  ={
   'ProjectType': $formSelectPermitType.state.permitSubtype.value
}

  This is then sent to the server-side workflow with a Run SQL Query activity. This then attempts to run a stored procedure which takes @ProjectType as a variable. 

  This is returning the following error in the browser:
  Must declare the scalar variable \"@ProjectType\"."

  0

Vous devez vous connecter pour laisser un commentaire.