how to use the string value from an autoComplete box in a query?

Majdoleen Awadallah

June 22, 2022 09:56

I have a very simple workflow that has a form with three fields (text box1, textbox2 and AutoComplete Box) and I would like to query and zoom to the feature based on the entered values (Ex (1) number, (2)number, jefna (string). However, it fails on the query. The AutoComplete box populates correctly, but when the user hits submit, the workflow fails

 

I am using this as my where clause: =`${$ParcelNo.result} = ${$searchForm.state.ParcelNumber.value} and ${$Block.result} = ${$searchForm.state.BlockNumber.value} and ${$CommunityName.result} = ${$searchForm.state.CommunityName.Label}`

P.S: “searchForm.state.CommunityName.value” is empty”

  

It doesn't seem to be passing the string value correctly. I think I am missing something!

 

Has anyone else successfully been able to query using an AutoComplete string value.

 

0

• 

  Daan Molleman

  June 28, 2022 13:18

  Hi Majdoleen,

  I have done something similar to your workflow where the result value of an autocomplete box is used in a query.

  =`STATE_NAME = '${$form1.state.autoComplete1.value}'`

  I think the left part of the = sign should always be hardcoded.

  I am not sure if this is what you are looking for, but I hope it helps.

  Cheers, Daan

  1
• 

  Majdoleen Awadallah

  June 29, 2022 10:38

  Hi Daan,

  I solved the issue and forgot to write the answer here, you are right, the problem was in the query with the left part!

  Thank you for your answer and help, really appreciate.

  Best

  Majdoleen

   

   

  0

Please sign in to leave a comment.