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
-
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 -
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 -
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 -
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 -
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 -
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
Du måste logga in om du vill lämna en kommentar.
Kommentarer
6 kommentarer