Server-side filter returns SQL error when using "contains" or "starts with" clauses

@formerstaff

I tried what you recommended with DF 2.0.4 and was not successful. Incidentally, I used to get this working with filters with DF 2.0.2 but noticed that now the params sent as date for filtering is creating problems.

{“error”:{“context”:null,“message”:“Failed to retrieve records from ‘ch_notifications’.\nDateTime::__construct(): Failed to parse time string (2016-01-15 and ins_ts <= 2016-01-15 and de41 like %2070%) at position 11 (a): The timezone could not be found in the database”,“code”:500,“trace”:[“0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Resources/BaseDbTableResource.php(486): DreamFactory\Core\SqlDb\Resources\Table->retrieveRecordsByFilter(‘ch_notification…’, ‘ins_ts >= 2016…’, Array, Array)”,“1 [internal function]: DreamFactory\Core\Resources\BaseDbTableResource->handleGet()”,“2 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(271): call_user_func(Array)”,“3 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(177): DreamFactory\Core\Components\RestHandler->processRequest()”,“4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(224): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), ‘ch_notification…’)”,“5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseDbService.php(116): DreamFactory\Core\Components\RestHandler->handleResource(Array)”,"6