I have the need to do this :

Let's say we have this table with movies and actors

1 : Solitary Man : Michael Douglas
2 : Solitary Man : Susan Sarandon
3 : The Game : Michael Douglas


Initially, I have some SQL to show this table ordered by Movie. It looks ugly with the movie name being repeated over and over, so I want it to look like this, turning the sort field into table headers:

SOLITARY MAN
Michael Douglas
Susam Sarandon

The Game
Michael Douglas

If I then click the sort buttons in the column header to sort by actor, it should change to :

MICHAEL DOUGLAS
Solitary Man
The Game

SUSAN SARANDON
Solitary Man

That is, the field used for ordering should always be displayed as table headers, not as columns. Is this in any way possible? Or could you consider it for a future update? I have tried to look into the code to perhaps make the change myself, but I am not sure what file to look in.

Hello,

Sorry, but the extension doesn't support this ability and we don't have this feature in our roadmap.

Regards,
ARI Soft

I was afraid that this is the case, which makes the module useless for my purpose. Could you point out to me, what files I would have to dig into, to work it out myself?

What table widget you use?

Regards,
ARI Soft

I am using Datatable, but could change it if nescessary.

"ARI Datatable" widget uses DataTables jQuery plugin. It uses <joomla_directory>\modules\mod_aridatatables\includes\js\widgets\datatable\js\jquery.dataTables.min.js file. Original version of this file can be found on jQuery plugin's home page or we can send it by email. It requires to change the file if you want to change widget behavior.

Regards,
ARI Soft