APEX v23.2
Problem:
We have a popup LOV on a list of organisations.
User enters: A & C Test Organisation
It returns all organisations with ‘A’ or ‘&’ or 'G' and the word 'Organisation'. The search is just a bit poor and not returning accuate results. It works perfectly when we add quotes but the users might not (I'm being kind, the users of this app absolutely won't) know about adding quotes to a search, especially not in an LOV.
So is there a way to make an LOV search as if the search term was in quotes?
Thanks
Lee