Error filtering grid

Suite and Optimus Suite 5
#1

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

grid.png978×269 10.4 KB

#2

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

#3

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

#4

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