Replies Back to Article

Ajax DataGrid

Great extension and fast ajax but....
October 29, 2008 by Sofus Comer

Hi George and crew. Nice design on your extension Ajax DataGrid. Both the way the extension works in DW and also the output. But sadly to say. Unless there is someway to actually be able to alter the SQL to more advanced queries its rather useless for me and a waste of money. Very rarely do i only make use of one table in MySQL, but sometimes 2 or three. If its possible to do this somehow now or in a later 1.0.4+ update hurray!!!

Kind Regards

Sofus Comer, Denmark

RE: Great extension and fast ajax but....
October 30, 2008 by George Petrov

Hi Sofus,
Thanks for your compliment! About more complicated queries it is actually no problem - you just need to define a VIEW from your complicated query in MySQL and then you can use the VIEW just like a simple table in the Ajax DataGrid!

Greetings,
   George

RE: RE: Great extension and fast ajax but....
October 30, 2008 by Sofus Comer

Hi George and thanks for your quick reply.

I am happy to hear that. But i am kinda lost as to where this VIEW is defined on which code page?

Maybe you can give us an example to where we put the sql code. Maybe others will benefit from a small tutorial like that.

Kind Regards
Sofus

PHP
// SQL begins

// END of SQL

This is a first class extension
December 20, 2011 by Chris Garner

I am extremely happy with this extension. I am using one grid to drive another grid and my customer is over the moon about it. Many thanks DMXzone. May you all have a happy and peaceful Christmas!!

Love the data grids!!!! Only one issue....
October 2, 2012 by Brett Power

The only issues I have is that I cannot search each column in the grid directly from the column headers and I cannot compound-sort.  Can this be possible???  Really similar to the way jQuery grids work.