[BUG] sql LIKE a% recent commit breakage

[leeburstroghm]

is this issue posted here http://fabrikar.com/forums/index.ph...-commit-breaks-alpha-index-like-clause.37460/

Like in sql now does not work when used in search.. as is used in the alphindex that did work in the past.

 

[cheesegrits]

Yeah, we made a little change to how 'LIKE' gets handled.

Can you change your condition to BEGINS? And you can remove that %25 as well, so ...

http://www.phys-dev.samaritanhealth...alue]=H&fab_services___name[condition]=BEGINS

It should be fairly obvious ow to change that script you are using from the Wiki. I haven't modified that, as thats under the 3.0 section, which will still work with the old "LIKE" way.

-- hugh

 

[leeburstroghm]

Huhg. Thanks.. I was not sure if that would apply or not. I will change that right away. not a big deall. eh.. Thanks for responding! YAY!

 

[cheesegrits]

Just to be clear ... in 3.1 we now have "begins", "ends" and "like" (or "contains") as conditions, and automatically add the %'s as you would expect, so if your value is 'foo' ...

BEGINS give you LIKE 'foo%'
ENDS gives you LIKE '%foo'
LIKE (or CONTAINS) gives you '%foo%'

So use one of those conditions, and don't provide your own %'s. If you need to search for a %, you can escape it, like "20\% of foo".

-- hugh