Start Building Professional
Web Apps Today

grid complex header database

Dear Team,

I'm using the latest version of the DHTMLX Grid component.

From your examples I managed to display a grid, with values from a MySQL database through PHP, and I can apply a filter to it using textfields on my page outside the grid (i.e. I used the '50,000 records in grid with paging'-example).

Now I'm trying to put those search fields in the headers of my grid like the 'Complex content in header'-example.

I tried to alter the examples to fit my needs, but I can't get it to work.

Could you please help me in the right direction or give me a working sample of the '50,000 records in grid with paging'-example with filters in the header?

Regards

There are some predefined types of filters (this is PRO Edition functionality) which can be embeded into grid header very simply - just typing there code names in header labels: like #text_filter, #numeric_filter. More detailed description can be found here: http://www.dhtmlx.com/docs/products/dhtmlxGrid/doc/guide.html#grid_filtershdr

Sampleis here: http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/filtering/pro_filter_num.html?un=1230569168000

Wow, thank you. That really is ridiculously simple...awesome.

Is this functionality new since version 1.6? Because I've spent a lot time working with the '50,000 records in grid with paging'-example, that I now render as obsolete. Or are there limitations/drawbacks to that simple functionality compared to the '50,000 records in grid with paging'-example?

Built in filters works with static loading only so they will not work for dyn. loading methods ( dyn. srnd or dyn. paging )
Technically you can still use them and catch filtering calls through onFilterStart event
http://dhtmlx.com/docs/products/kb/index.shtml?cat=search&page=1&q=6068&ssr=yes&s=onFilterStart

Other solution, for dyn. loading case, will be usage of custom input boxes in header ( with custom logic attached ) , which can be created by using inline html elements in attachHeader command.
grid.attachHeader("a, <input type='text' onkeypress='any custom call'> ,c")

>>Is this functionality new since version 1.6?
Functionality available starting from dhtmlxgrid 1.5, but it was seriously improved starting from version 1.6