Grid Filtering during Dynamic Loading

Suite and Optimus Suite 5
#1

Hi,

I have a database with a lot of entries (sometimes in the millions). On the JavaScript side I load the data into the filter using an XML file created with PHP and I have smart rendering enabled. I am currently using the built-in filters for each column I want to enable filtering. If the user has not scrolled down to load more data, filtering only assumes the data that has been pre-loaded. Therefore when a user wants to search for an entry in the database that is not in the initial load (I pre-load the first 100 entries), that entry appears not to be found.

Since we are currently using DHTMLxGrid v1.6 Professional version, I was wondering if:

(1) There is a better(built-in) way that I am not aware of in order to filter/search in the grid (v1.6) while assuring that the large amount of entries gets loaded without crashing the browser (loading without smart rendering crashes and/or slows down the browser due to the large amount of entries). Please note that I understand that there are ways to achieve this by writing additional code but I am interested in finding out whether there is such functionality built into the grid before writing more code.

(2) We need to upgrade to a newer version that includes this functionality. If this is an option, how would I achieve the functionality mentioned above, with the new version of the grid? Any examples?

Thank you,

firmiboy

#2

There is no built in support for server side filtering in grid 1.6
It will not require very complex code , think. You can catch onFilterStart event and reload the grid with new data from it.

Starting from grid 2.5 - there is a server side filtering through connectors - but this logic do basically the same , it catches filtering and reload data, it just hides all reloading logic.

Grab dhtmlx.com/x/download/regula … 10_php.zip and check
samples\grid\01_basic.html

mygrid.attachHeader("#connector_text_filter,#connector_text_filter")