Search alternative for PostgreSQL and SQLite

Question

Search alternative for PostgreSQL and SQLite

Closed this issue 10 years ago · 2 comments

Currently searches are done using MySQL's match against syntax which is not supported on PostgreSQL or SQLite so we should find an alternative that will work in all languages.

Answer 1 · 2014-07-13T17:29:00.000Z

Could switch to like what the cms does for terms https://github.com/silverstripe/silverstripe-cms/blob/072e0d98053cd10b7ae55ccdc598ae950351c279/code/controllers/CMSSiteTreeFilter.php#L146-L151

Answer 2 · 2014-07-13T23:14:51.000Z

Fix for this was to use match against for MySQL and PartialMatchFilter for all others. In the future we may change this to be PartialMatchFilter for MySQL as well.