Make `FulltextFilter` more generic, so that modules can add support for databases besides MySQL

silverstripe / silverstripe-framework

Silverstripe Framework, the MVC framework that powers Silverstripe CMS

https://www.silverstripe.org

BSD 3-Clause "New" or "Revised" License

720 stars 822 forks source link

Make `FulltextFilter` more generic, so that modules can add support for databases besides MySQL #11018

Open sabina-talipova opened 9 months ago

sabina-talipova commented 9 months ago

Description

FulltextFilter currently has some code that is specifically MySQL syntax. We should make this more abstract so that community modules for postgresql, mssql, etc can work with this filter.

See: https://github.com/silverstripe/silverstripe-framework/blob/cf78a9d785b9959a92dfb52c2a456bea80a4c567/src/ORM/Filters/FulltextFilter.php#L28