Filtering with #text_connector_filter is case sensitive PHP

Suite and Optimus Suite 5
#1

I have a problem with connector filtering with Oracle. What I want is Case-INsensitive filtering on the server side with #connector_text_filter. But It doesn’t work. The filter is always case-sensitive.
I’m using “Oracle Database 11g Enterprise Edition”, 11.2.0.1.0, 64bit Production on Windows Platform and PHP-connector.
Attached a ZIP File to show the problem. I have 2 Grids, one with #text_filter and one with #connector_text_filter. The SQL creates the oracle table EMPLOYEES and inserts 5 rows.
What I want is server side case-INsensitive filtering with #connector_text_filter connected to an oracle database. Can somebody help me:?:
Thanks in advance.
connector_filter_case_sensitive_problem.zip (374 KB)

#2

You can redefine the SQL code which is generated for data filtering.

docs.dhtmlx.com/connector__php__ … event.html

You can use something like next

[code]function custom_filter($filter_by){
$index = $filter_by->index(“FIRST_NAME”);
if ($index!==false) {
$value = $filter_by->rules[$index][“value”];
// any sql code here
$filter_by->rules[$index]=“FIRST_NAME LIKE $value”;
}
}

$grid->event->attach(“beforeFitler”, “custom_filter”)
$grid->render_table(“EMPLOYEES”,“EMPLOYEE_ID”,“FIRST_NAME,LAST_NAME”);[/code]

#3

I added the custom_filer logic, but unfortunately it’doesn’t work :neutral_face: :neutral_face: :neutral_face:

<?php $db_user="gkstatdev"; $db_pass="gkstatdev"; $db_name="HEDALDEV"; $res = oci_connect($db_user,$db_pass,$db_name); if (!$res) { $err = oci_error(); $err = oci_error(); // for connection errors do not pass a parameter var_dump($err); print "\nError code = " . $err['code']; print "\nError message = " . $err['message']; print "\nError position = " . $err['offset']; print "\nSQL Statement = " . $err['sqltext']; print htmlentities($err['message']); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } function custom_filter($filter_by){ $index = $filter_by->index("FIRST_NAME"); if ($index!==false) { $value = $filter_by->rules[$index]["value"]; // any sql code here $filter_by->rules[$index]="FIRST_NAME LIKE $value"; } } require("../../codebase/grid_connector.php"); require("../../codebase/db_oracle.php"); $grid = new GridConnector($res,"Oracle"); $grid->dynamic_loading(50); $grid->event->attach("beforeFitler", "custom_filter"); $grid->sql->sequence("EMPLOYEES_INC.nextVal"); $grid->render_table("EMPLOYEES","EMPLOYEE_ID","FIRST_NAME,LAST_NAME"); ?>