Error in Filter in dtmlxGrid

Suite and Optimus Suite 5
#1

I am using dhtmlxGrid with filter but the problem is that the special characters in column are replaced with html code in the filter

index .php code:

mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setImagePath(“codebase/dhtmlxGrid/imgs/”);
mygrid.setSkin(“modern”);
mygrid.setHeader(“Business Service, Service, Service Description, Service Type, User CI”);
mygrid.setInitWidths(“200,*,200,300,100”);
mygrid.setColAlign(“left,left,left,left,left”);
mygrid.setColTypes(“txt,txt,txt,txt,txt”);
mygrid.attachHeader(“#select_filter,#text_filter,#select_filter,#select_filter,#text_filter”);
mygrid.setColSorting(“connector,connector,connector,connector,connector”);
mygrid.enableMultiline(true);
mygrid.init();
var source = “php/get_data.php”;
mygrid.loadXML(source);

get_data.php:

try {
$dbh = new PDO(“oci:dbname=boms10.world”, “aixboms_admin”, “aixboms”);
$grid = new GridConnector($dbh, “PDO”);
$grid->render_table(“MCK_SERVICE_CATALOG”, “OBJ_NO”, “BUSINESS_SERVICE,SERVICE,SERVICE_DESC,SERVICE_TYPE,USER_CI”);
} catch (PDOException $e) {
echo "Failed to obtain database handle - error: ". $e->getMessage();
}

see attached image. Please help.

#2

Unfortunately this is known issue of HTML parser. Try to use “txtxt” eXcell type. This eXcell type treats values as pure text, so no HTML is allowed and all special chars can be set without escaping.

#3

Is this still a bug in Grid 4.0?

#4

The solution is still actual.
Please, try to use the txttxt column type instead txt, and edtxt instead of ed.