Start Building Professional
Web Apps Today

filter on grid say 'row is null'

Hi,

We're using the Enterprise edition of dhtmlx suite.

All working great so far, however I'm having some trouble using filers on a grid.

Here is what I am doing:

var ajaxNumbersGrid;
function ajaxNumbersGridInit()
{
ajaxNumbersGrid = new dhtmlXGridObject('ajaxNumbersGridContainer');
ajaxNumbersGrid.setImagePath("/3rdparty/dhtmlx/imgs/");
ajaxNumbersGrid.setHeader("Number,DDI,Network,Tariff,Usage,Allocated,Notes");
ajaxNumbersGrid.setInitWidths("100,100,80,80,80,200,*");
ajaxNumbersGrid.setColAlign("left,left,left,left,left,left,left");
ajaxNumbersGrid.setColSorting("str,str,str,str,str,str,str");
ajaxNumbersGrid.setColTypes("ro,ro,ro,ro,ro,ro,ro");
ajaxNumbersGrid.enableMultiselect(true);
ajaxNumbersGrid.setSkin("light");
ajaxNumbersGrid.enableSmartRendering(true,50);
ajaxNumbersGrid.makeFilter("filterNumber",0);
ajaxNumbersGrid.init();
var url="data.php";
url=url+"?sid="+Math.random();
ajaxNumbersGrid.loadXML(url);
}

The filterNumber filter is not working. When I type in the input box Firefox errors 'Row is null'.

I am using the alli-in-one js and css files.

Please help.

We cannot reproduce this problem locally. Please provide sample where this issue occurs including files which you are using to initialize grid directly to the support@dhtmlx.com

Hi,

Thank you for the quick response.

I have been testing the issue and narrowed down the cause, I cannot sort the grid or filter columns unless all data is loaded. I can load all data by scrolling through the entire grid before sorting, I assume this caches the data locally.

The docs seem to suggest it is possible to filter and sort using smartRendering, is there anything special to do this?

I can't send files as the data.xml contains sensitive data and has 77,000+ records. I tried to create a sample with only 10 records but it worked as the data was sent in one chunk and was cached locally. It only fails if only part of the dataset is sent to the client using smartRendering.

Thanks,

Martin

Yes, I am using dynamic smart rendering.

I see a method for server-side sorting, that should solve that issue.

I can't see any method for client-side filtering though. I would like to filter columns based on input text, is this possible using dynamic smart rendering? One of your examples shows filtering data using an input box with 50,000 records. Does that example not use dynamic rendering?

Thanks,

Martin

Hi,

I've changed to server-side filtering and it is working great, thanks.

It is all working here now, although I am still curious how this example works:

http://dhtmlx.com/docs/products/dhtmlxGrid/samples/loading_big_datasets/50000.html

It suggests it uses client-side filtering using dynamic smart rendering, which is what I wanted to do. Is it filtering on the client or server?

Thanks.

This example using dinamically Smart Rendering mode. To filter rows we are using server side sorting with help “onBeforSorting” event which available only at PRO version.

Aah okay, that explains it, thank you.