How do you use a double in an autocomplete box? In WF4 you could CAST the object to a varchar to get the 'like' statement to work

Chris Wright

6. April 2020 12:15

0

• 

  Permanently deleted user

  7. April 2020 00:54

  Hi Chris,

  Can you clarify a bit? Which activity/input (in an autocomplete event or after the form) are you wanting to use a double in?

  0
• 

  Chris Wright

  7. April 2020 06:17

  Hi Amanda, so I want to search on a field that could be a double or an integer instead of a string. So instead of searching for a house name, search for an apartment id which is either a double or an integer

  0
• 

  Chris Wright

  22. Mai 2020 10:01

  I think I have resolved this. What I did was to convert the input to a string in the query activity of the suggestion part of the autocomplete form (In the where clause)

  0
• 

  Permanently deleted user

  18. Juni 2020 12:11

  Chris,

   

  Can you explain a little bit more. I'm trying to do the same but like'%123' is not working for numbers. I tried to_char and other options but i won't work. It is quite logic if it not working but if there is a way I would like to know.

  0
• 

  Chris Wright

  18. Juni 2020 12:41

  Hi Eric,

  Basically what I did is the following;

  1) I have an autocomplete in my display form

  2) In the suggestions of the autocomplete there is a query task

  3) In the Where clause of the query task I enter

   

  ="PROPERTY_REF LIKE '" + $getFormEventData.argument.toString() + "%'"

   

  $getFormEventData.argument comes from the GetFormEventData

   

  I hope this helps

  0
• 

  Permanently deleted user

  18. Juni 2020 13:02

  Thanks Chris,

   

  My workflow is a little bit different I think. I need to autocomplete a number field and that does not work with like. Thanks for the quick response anyway.

  Erik

   

  0

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