Hello,
using SmartGWT: SmartClient Version: v8.3p_2013-01-09/PowerEdition Deployment (built 2013-01-09)
One of the filter editors in one of my grids in my app (it's a dropdown listgrid in a SelectItem), generates the following criteria
and then is transformed, eventually, into
The LIKE BINARY makes it case-sensitive, from what I understand. Why is this BINARY being added, and how can I prevent this?
Other grids in my app just make it
Which is what I would like to happen.
How can I achieve this?
using SmartGWT: SmartClient Version: v8.3p_2013-01-09/PowerEdition Deployment (built 2013-01-09)
One of the filter editors in one of my grids in my app (it's a dropdown listgrid in a SelectItem), generates the following criteria
Code:
=== 2013-02-12 09:48:10,254 [or19] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ surname:"Mee" }, operationConfig:{ dataSource:"Exam_participants_Student", operationType:"fetch", textMatchStyle:"substring" }, startRow:0, endRow:75, sortBy:[ "surname" ], componentId:"isc_PickListMenu_5", appID:"builtinApplication", operation:"customField", oldValues:{ surname:"Mee" } }
Code:
SELECT COUNT(*) FROM Exam_participants_Student INNER JOIN Student ON Exam_participants_Student.Student_id = Student.Student_id INNER JOIN Exam ON Exam_participants_Student.Exam_id = Exam.Exam_id INNER JOIN Block ON Exam.Block_id = Block.Block_id LEFT OUTER JOIN ExamStructure ON ExamStructure.ExamStructure_id = Block.ExamStructure_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE ('1'='1' AND ((Student.surname LIKE BINARY '%Mee%' AND Student.surname IS NOT NULL)))
Other grids in my app just make it
Code:
LIKE '%Mee%'
How can I achieve this?
Comment