4.5 Dynamic Loading, Filter.

Suite and Optimus Suite 5
#1

Hi:

This is a long question, my version could be the problem - maybe I need to upgrade.

Setup:

  1. I have a grid. (attached to a sidebar.)

grid= sBar.cells(“tasks”).attachGrid();

  1. I have dynamic Loading on.

grid.enableSmartRendering(true);

  1. I added filters to my grid:

    for(var cols=0;cols<grid.getColumnsNum();cols++)
    {
    if (cols > 0)
    filterList = filterList + “,”;
    var colType = grid.getColType(cols);
    switch (colType){
    case “ed” :
    case “tree”:
    case “ro” :
    filterList = filterList + “#connector_text_filter”;
    break;
    default:
    filterList = filterList + “”;
    }
    }
    grid.attachHeader(filterList);
    grid.setSizes();

  2. I load data into the grid:

     grid.load(loadUrlString);

  3. Return message is good:

…

(I only return 30 rows.)

  1. I scroll down and the correct paging type url is sent:

DHTMLXXML/list?parentId=XX~-1&Select_Type=null&ID=-1&Sel_Code=EV&now=1507884182657&connector=true&dhx_no_header=1&posStart=177&count=23&

  1. I filter for something, the call and return are fine:

call:
DHTMLXXML/list?parentId=XX~-1&Select_Type=null&ID=-1&Sel_Code=EV&now=1507884182657&connector=true&dhx_no_header=1&posStart=177&count=23&
…&dhx_filter[2]=e&…

return:
…

Again I only return 30 rows.

  1. I scroll down.

*** Here is my problem I expect the same message as in point 6. to be created. But nothing happens. No message is sent, no errors in my Javascript console.****

Do you have any thoughts?

#2

such kind of the dynamic loading is not available for the treeGrid.
You should use the following dynamic loading:
docs.dhtmlx.com/treegrid__manip … intreegrid

#3

Hi:

I am not using a tree or tree grid.  :slight_smile:

To start, Look at your page:  [dhtmlx.com/docs/products/dhtmlx ... _srnd.html](https://dhtmlx.com/docs/products/dhtmlxGrid/samples/08_filtering/05_pro_filter_srnd.html)  

That page shows how to add filters to a smart rendering page. But that filter only filters rows currently loaded into the front end. The customer wants to filter over all rows even those on the server. (So if I have 1000 rows, 30 loaded to the front end and I type z I get only rows from the first 30 which contain a z.)

To filter over all rows on the server you need to change the #text_filter to a connector filter: #connector_text_filter The connector filter goes back to the server to perform the filter. Therefore I can filter over all rows. Instead of filtering on the front end we do it on the server. (Using the connector filter  the system passes same URL as the load but adds to the url dhx_filter[0]=&dhx_filter[1]=test&.......... The server then returns the new rows to the front end.  )

 Look at this also

docs.dhtmlx.com/connector__php__filtration.html

There are no examples for using the connector filter.  

 So, I use the connector filter with a normal grid. The filter works correctly. But actually I see two issues.

  1. After filtering, when I scroll down I expect the system to go back to the server to (attempt to) pick up the next 30 filtered rows.

  2. If the filter only has 50 rows the screen still shows space for the original 1000 rows. (I do not care.)

    I think that the functionality is very nice, this is not a complaint. But it does not quite work for me, or I am doing something wrong, or maybe it works in the latest version?

#4

I see.
Unfortunately the problem cannot be reconstructed locally.
additional dynamic loading requests load correctly for me after the filtering is applied.
Could you please, provide a demo link, where the problem can be reconstructed.

#5

I can give you a demo link. But before we went that far…

I do not use your connector - are you? I have dhtmlxsuite professional. From that suite I am using just dhtmlx.js.

Inside the normal suite #connector_text_filter exists and so that is what I use as my filter. My problem is that the xmlFileUrl url is being set to “” (empty string). I also switched paging on because I would prefer to use paging and server filtering. In clearAll just before:

	if (this.pagingOn)
		this.changePage(1);

if I added
if (this.pagingOn || this._srnd)
{
var ii = this.xmlFileUrl.indexOf(“posStart=”);
if (ii > 0)
this.xmlFileUrl = this.xmlFileUrl.substring(0,this.xmlFileUrl.indexOf(“posStart=”)-1)
}

I think that this is the only change that I made (i had to link to all of the single .js files) My problem now is that it asks my server twice for the filter and not just once. But I think that I should be able to fix that. Your code is setting the url to empty - makes sence for clearAll to set it to empty.

I think that you are just using the connector and that your xmlFileUrl is not being reset, or somehow the extra connector code resets the value?