data columns displayed

Hello again,

The "dispaly data" link works fine, however, the columns are displayed unsorted and the title is the LABELs and not the ALIASes. In my form, some LABELs are repeated twice, so it's quite difficult to sort out wich column it is.

Is it possible to have the column sorted ? to display the aliases ?

Thanks

Paul

Hi Paul,

for this you have to change a bit of code. Sorry for that. I will adapt the component in the next update.

to show the aliases you have to open

yourJoomlaInst/administrator/componenten/com_visforms/views/visdata/tmpl/default.php

search for the following code (about line 147)

<?php echo JHtml::_('grid.sort', $rowField->label, 'a.F'. $rowField->id, $listDirn, $listOrder); ?>

and replace it with

<?php echo JHtml::_('grid.sort', $rowField->name, 'a.F'. $rowField->id, $listDirn, $listOrder); ?>


For the ordering open file

yourJoomlaInst/administrator/componenten/com_visforms/models/visdata.php

search for the following code(about lin 269) in public function getDataFields()

$query = ' SELECT * from #__visfields as c where c.fid='.$this->_id.' ';

and replace it with

$query = ' SELECT * from #__visfields as c where c.fid='.$this->_id.' ORDER BY c.ordering ASC ';

Sorry you have to change code in my extension but it's the only way.

Regards,
Aicha

Excellent ! quite doable even for a non-expert !!
Thanks

Hi Aicha

I would like to sort the table while displaying by Name which is set to F1 field. Please suggest.

Thanks

Hi parashuram,

there is no parameter to set a default sort coloum for data view in frontend. Usually you would have to set the the parameter "show table headings" in the frontend data menu item to yes and users could sort record sets then according to their requirements by clicking on the the table heading of the column they want to sort by.

To make it work as a parameter you can set in backend is much more complicated and would need proper testing. Therefore no code here. Sorry.

Kind regards,
Aicha