On Fri, 19 Sep 2008, Syed Haider wrote:
Hi Richard,
I am afraid, there no such option unless you want to hack the sql
compiler :)
I came across the same thing recently. Maybe it would be good to have
something in the SQL compiler to automatically add %'s if the operator is
LIKE (or whatever postgres and ORACLE). I seem to remember there was a
reason we did not do this originally though
cheers
syed
On Fri, 2008-09-19 at 15:47 +0100, Richard Holland wrote:
Hello.
When I make a 'like' filter, I have to type '%' signs into the filter
value to indicate the position of the wildcards.
Is there any type of filter I can use where it internally
automatically adds '%' to both ends of the filter value before
searching?
In other words, I'd like to have a filter on the page where I can just
type a word and it will return me all records containing that word,
not just equal to it.
cheers,
Richard
