What should the WHERE clause in a Query activity look like when the Query needs to reference the feature/value Submitted from a Display Form dropDownList subworkflow Query activity?

Permanently deleted user

21. Oktober 2020 15:28

Subflow appears to be working and produces the Form Element items, however, I can't find a good example of a Query activity WHERE clause that fetches the value from the user's dropDownList submission to Show Results.

 

Any help/suggestions would be greatly appreciated.

1

• 

  Permanently deleted user

  12. November 2020 07:53

  Something like this if the attribute type you use in your WHERE clause is string:

  = "AttributeName = '" +$form1.state.dropDownList1.value + "'"

   

  Do note the apostrophes in the above statement.

  1

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.