Error filtering grid

Hi, I have a problem with filtering data in the grid. Below I have set an example of code. Tell me what I’m doing wrong. The answer comes from the server is correct, but the data are displayed in the grid is not correct.

HTML:
var manipulationGrid, dp;
manipulationGrid = new dhtmlXGridObject(‘id_manipulation’);
manipulationGrid.setImagePath(“…/dhtmlx/imgs/”);
manipulationGrid.setHeader(“IDCat,Warehouse,Part Code,Lot Number,Part Code Name,Picking Location,Qty On Hand,Retail Price,Price (40%),Price (80%)”);
manipulationGrid.setInitWidths(“,,,,,,,,,”);
manipulationGrid.setColTypes(“ed,ed,ed,ed,ed,ed,ed,ed,ed,ed”);
manipulationGrid.setDateFormat(‘%Y-%m-%d’);
manipulationGrid.setColSorting(“int,str,str,str,str,str,int,int,int,int”);
manipulationGrid.enableSmartRendering(true);
manipulationGrid.enableMultiselect(true);
manipulationGrid.setMultiLine(false);
manipulationGrid.enableDragAndDrop(true);
manipulationGrid.init();
manipulationGrid.loadXML(“server/get_productresidues.php?IDCat=” + mas);

     var dp = new dataProcessor("server/get_productresidues.php");
     dp.init(manipulationGrid);

HTML event:
manipulationForm.attachEvent(“onButtonClick”, function(name){
if(name==“Find”) {
var fil=“10075663”;
var lot=“KV188879”;
manipulationGrid.loadXML(“server/get_productresidues_filter.php?IDCat=” + mas + ‘&Filter=’ + fil);
});

PHP:

<?php include '../db_params/config_mysql.php'; require("../codebase/db_mysqli.php"); require("../codebase/grid_connector.php"); /*Part variable*/ $IDCat=$_GET['IDCat']; $Filter=$_GET['Filter']; $Lot=$_GET["Lot"]; $grid = new GridConnector($dbData, "MySQLi"); $grid->enable_log("some.txt", true); $grid->dynamic_loading(4000); $grid->sort("IDProdResidues", "ASC"); $grid->filter("IDCat in (". $IDCat . ") and PartCode='" . $Filter . "'"); $grid->render_table("product_residues","IDProdResidues","IDCat,Warehouse,PartCode,LotNumber,PartCodeName,PickingLocation,QtyOnHand,RetailPrice,Price_1_40,Price_1_2_80"); ?>

The answer comes correct

<?xml version='1.0' encoding='utf-8' ?>


But grid displaed wrong information. Please help me understand


Unfortunately such an issue cannot be reproduced locally.
Could you please, share with a demo link, where the problem can be reconstructed locally.

I have the same problem - the first 2 lines will display … not more. I can fix it, by using the standard dhtmlx.css Style file. Why - I don’t know :slight_smile:

Dirk

Please, try to update the version of your dhtmlxSuite/Grid.