Feature Query with wildcard / LIKE operator for form autocomplete

Permanently deleted user

10 Juni 2019 16:59

In Workflow4 one could specify something like Location Like '{0}%' in order to have the AutoComplete start to populate. What's the equivalent in GW5?

 

Thanks,

James

0

• 

  Zack Robison

  10 Juni 2019 17:37

  There is an example for this that ships with WF5. In Workflow designer, navigate to File > New > Samples - Form - Autocomplete. The sample is a fleshed-out version of the ArcGIS Query subworkflow template that you can select when adding an autocomplete form element.

  0
• 

  Ken Lyon

  10 Juni 2019 19:46

  Quick answer: The syntax in that example is:

  =`UPPER(STATE_NAME) LIKE UPPER('${$textReplace1.result}%')`

  Longer answer: In that sample, you can see the syntax for what you're trying by doing the following:

  • In the workflow designer, double-click on the "Display Form" step.
  • The form designer appears. Double-click on the middle row of the form to edit the Suggestions subworkflow for the "Auto Complete" element.
  • The workflow designer for the suggestions event appears. Click on the "Query Layer" step.
  • In the right column, locate the "Where" input and click the "Expand" button.
  • You can now see the expression that is used in the query.

  0
• 

  Permanently deleted user

  10 Juni 2019 20:02

  Much appreciated to you both - just starting out with GW5...working as should!

  Thanks,

  James

  0

Du måste logga in om du vill lämna en kommentar.