sort order in visformsdata.php for list/getDetai

Hi,
i want to sort the output of one visform in frontend.
For the selection i found in visformsdata.php the function getDetail().
I try to add "order by.." but the output is still the same.
I think my practical experience of php/SQL is not very well so i didn't find the mistake.

original:
$query = ' SELECT * FROM #__visforms_'.$this->_id.
' WHERE id = '.$id;

new, test:
$query = ' SELECT * FROM #__visforms_'.$this->_id.' WHERE id = '.$id. ' order by F4 asc';

Could someone please assist?

Thanks a lot

Hi Schuetze,

the getDetail function is the wrong place. It does (as the name says) get the details of one recordset (to display them when you enable the "display details" parameter in form.

If you want to use another field than the "id"-Field as a default to sort the dataview (list) in frontend and you change the components/com_visforms/models/visformsdata.php you will not be able to use more than that one form (because fieldnames are unique in visforms and you have only that one form with the field which you going to write into the php file hard coded).

If that is ok for you try to change the function populateState in the same file.

Replace

with
(Assuming F4 is the field you want to use) that will solve your problem.

Regards,
Aicha

Thanks a lot.
You made my day.

You're wellcome!

Administrator wrote: the getDetail function is the wrong place. It does (as the name says) get the details of one recordset (to display them when you enable the "display details" parameter in form.

If you want to use another field than the "id"-Field as a default to sort the dataview (list) in frontend and you change the components/com_visforms/models/visformsdata.php you will not be able to use more than that one form (because fieldnames are unique in visforms and you have only that one form with the field which you going to write into the php file hard coded).
If that is ok for you try to change the function populateState in the same file.
Replace

Code:

parent::populateState('a.id', 'asc');

with

Code:

parent::populateState('a.F4', 'asc');

(Assuming F4 is the field you want to use) that will solve your problem.

I saw this and was hoping to change the sort order of a.id from 'asc' to 'desc' but it looks as if this line is missing from the latest update, version 3.4.0, is there another place to make this change in that version?

Thanks,

Louis

Hi,

I made this menu item options.
You can now set the sort order field and the sort direction for each menu item (tab: Form Data Display Options)
So no code changes required any more

Regards,
Aicha