Hello,
I represent SQL and CSV without problems, but I have a query that is very complex and I think it is impossible to represent with ARI. The columns in each row represent different data. Is it possible, from php code, after filling out some arrays which are are represented in the table?. It would be a very powerful value added to the fantastic ARI datatables module.
Greetings.

Hello,

Do you format data in column(s) in specific way?

Regards,
ARI Soft

thanks for the quick response.
No formatting is different columns. My problem is this:
A B C D E ...
type-1 2 4 2 5 8 ... Results of SQL to table A
type-2 1 6 8 5 8 ... Results of SQL to table B and C
type-3 4 8 6 8 9 ... Results of SQL to table D
Totals .........

type-1
type-3

type-1
type-2
.....
That can not be done with SQL alone, but if I can build on that logic arrays data structure as if it were a "CSV in memory."
I can not think of another way to do it.
Is it possible to do so?.
I guess the ARI DataTables module does something like that, first read the CSV and fill some arrays which then formats and represents.
Anyway thank you very much for responding so rápiamente.
Best regards.

Data from a database are prepared in <joomla_directory>\modules\mod_aridatatables\includes\kernel\DataTables\Models\class.DataTablesDataSqlModel.php file. For CSV files in <joomla_directory>\modules\mod_aridatatables\includes\kernel\DataTables\Models\class.DataTablesDataCsvModel.php file. You can modify it for your needs or create a new source for PHP data.

Regards,
ARI Soft

very grateful,
I'll try.

Best regards.

Hello again,
Is it possible to create a new class instead of modifying an existing?.
For example, copy class.DataTablesDataArrayModel.php to class.DataTablesDataCsvModel.php and modify the latter.
Especially not to touch your code module in order to add functionality, not change it.
Best regards.