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