Projects/Full Text Search
Introduction
For the moment, we only support equality or contains searches whether being case sensitive or insensitive. This has a limitation because when searching for a multi-word pattern the user needs to correctly guess the order or if there are rows in different orders, it will not return all the results.
Example: When searching for products, if the user searches for blue shirt, the application can be demanded to search something that has the pattern 'blue shirt' in it, we can make the system ignore case, but we cannot return as a result nothing that has 'shirt blue' as a pattern in it