Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Filter editor resolves to LIKE BINARY

    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

    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"
        }
    }
    and then is transformed, eventually, into
    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)))
    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
    Code:
     LIKE '%Mee%'
    Which is what I would like to happen.
    How can I achieve this?

    #2
    Can you show the datasource? And the grid source if possible

    Comment

    Working...
    X