Different sort in tree module

[Thierry]

Hi Jan

Is it possible to change the sort order of the categories inside the Tree module

My caterogies appears by ID instead off alphabetical order

Thanks for your help

Thierry

[Jan]

Hi, this need to be customized in the module, you need to change the sql query...

Jan

[Thierry]

Hi Jan

I have no Sql query on Joomla's backend for this module.

Do you mean "Change a value inside one file of this module" ?

if Yes could you tell me which one ?

Thanks

Thierry

[Jan]

The sql query in module file:

modules\mod_phocagallery_tree\mod_phocagallery_tree.php

[Thierry]

Hi Jan

Thanks for your response

it's cc.title instead of cc.ordering inside this file

Regards

Thierry

[Jan]

Ok

[Karl1]

Hi Jan
thanks for the information.
I Tried "...cc.title desc" and this worked.

But my question: how is the field "ordering" populated and how can I change it (from Backend) ?
I can live with the solution above but I would prefer not to change a php...
Regards Karl

[Jan]

Hi, for now there is no option for it in module settings so there is nothing to change. You can only add the option there and implement it into the module.

Jan