mutilple search string from field through input box
Hi all,
My application has a input box as search box.
i have a field called "Category ID"
Category ID
Rank
US0071243
5
US0062711
3
AE1212121
2
AC0000121
3
CA1201921
3
IN12121211
4
My Question - i want to type any of the available string (category ID) in the input box, For Eg. US00*,AE00* then my straight table should bring both the combinations of Id's,
like this.
Category ID
Rank
US0071243
5
US0062711
3
AE1212121
2
In Input box i am using variable as vSearch and In Settings -> Document Properties -> Triggers -> Variable Event Triggers -> vSearch
->OnChange -> action as 'select in filed' -> in Field ( i am using Category ID) and in Search String ( i am using "=if(Len(vSearch)>0,'*|'& vSearch & '|*','')" )
by using this i am able to search single category Id, but if i am using replace i am unable to search multiple search.
Hi Sunny, I need multiple for the _SearchStr only.. Just now i check with the following expression for the SAID search ='("$(=Replace('$(vSearchSAID)',',','"|"'))"). I am able to search multiple SAID in input search for SAID's.
But if I use the same for the _SearchStr, I am unable to get the results. Both search are different. User can search based on the _SearchStr or SAID. Any one he can use for getting the results. Till now we are using Single search for SAID and _SearchStr. But now they are looking for entries in single search.
'mutilple search string from field through input box ' is very useful and i adpoted it for my project. I have created search string
='("$(=Replace('$(my_ID)',' ','"|"'))")
where i can simply copy list of my_ID from Excel table
my_ID1
my_ID2
my_ID3
and paste it in input box and it igot pasted in to a row format ( my_ID1 my_ID2 my_ID3) where there are two spaces in between IDs. The search is working with my expectations.
But when i "Turn on Web view', and repeat the same, the ID got pasted in to
