Before Oracle APEX 24.2, the POPUP LOV search using “%” worked as following :
If we have e.g. these product names :
Chocolate milk carton 80 ML
Chocolate milk carton 200 ML
Now if we want the first product :
Chocolate %carton %80
But now, in Oracle APEX 24.2, if we set Match Type = Contains the “%” mark not working, but Match Type = Start With behaviour support “%" mark but if we seach in a word in the middle of the product name I need to Write “%” at first e.g. if we want to search all products that contains milk, with Match Type = Start With we need to do the following :
%milk
Before this APEX release I think it works as expected.
Any idea how to use “%” percent with Match Type = Contains ?
Thank you.