dhtmlxgrid grouping

Suite and Optimus Suite 5
#1

Hello,

I’m working in a project in which I want to introduce a dhtmlxgrid object to grouping different data. I’ve been testing the Standard edition but I’ve realized that isn’t possible to get what we need.

So now I’d like to know if it’s possible to get what we need using the Pro edition.
I’ve a HTML web page which calls PHP to receive the data to introduce in the dhtmlxgrid object. I’m using “loadXML” function. The main problem is that if we create a request with “group by" or “order by” in PHP, dhtmlxgrid it doesn’t work.
Could we solve this problem using the Pro Edition? Could we sort the data?
In Standard edition isn’t possible to do?

Thank you
Regards

#2

Hi
do you mean this? This is not included in free version
http://docs.dhtmlx.com/doku.php?id=dhtmlxgrid:grouping

http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/07_extended_modes/01_pro_group.html

if this is not what do you mean:
Are you sure that your query is correct? (I mean do you get correct output even with “group by” or “order by” ?)
you can use this in your connector to get log:

$grid->enable_log('./logp.txt');

or else there is a possibility that you can make html table and then transform it to DHTML
http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/12_initialization_loading/03_grid_int_from_html.html

Personaly, I dont use loadXML function but I use :

grid.load(script.php)

and if I dont use connector I just “transform” the output to XML format (for grid… etc.) and its look like this:
http://www.dhtmlx.com/docs/products/docsExplorer/doc/dhtmlxxml/index.html