ordre d'affichage item-categorie chiffres apres les lettres

Bonjour,

Dans l'affichage des items de ma categorie, les items commencant par des chiffres s'affichent en premier puis les textes en ordre alphabetique..

Hors, je souhaiterai qu'ils s'affichent en dernier.

c'est à dire :
Item 1
Item 2
Item 2
1 Item
2 Item
etc
Y a t il des options a modifier ? un code a modifier pour cela ?

merci !

Ordering is done by SQL Query with is then limited to e.g. 10 to get 10 items per category page.

So what you ask is not trivial

1. Maybe it is possible to do something via hacking he SQL query of category view to create a TEXT manipulated column of category title and then order by it

2. Another alternative is to hack FLEXIcontent code extensively to retrieve ALL category items, do custom ordering in PHP , and then implement some custom category pagination

Number 2, i strongly discourage to DO,

About number 1, you could ask a freelancer MySQL developer

Best Regards

ok I'll try first option. On which file did you put the queries in order to try to modify it ?

thx

Please note that we discourage hacking flexicontent core code, as you will have difficulties upgrading, since you will have to reapply your customizations

The file to change is the frontend category model (Joomla architecture)

components/com_flexicontent/models/category.php

queries are on category.php ?

yes

ok great I'll try to do something ! thx

ok maybe let's imagine something different.

Would it be possible to order by alias instead of title ? So I could user different Alias from title to put at the end the titles beginning by numbers.

code would be easier to change and udpate as well.

what do you think about it ?

I don't recommend hacking code but if it is important to you could do add the code inside the [ADD]...[/ADD]:

in components/com_flexicontent/models/category.php

in administrator/components/com_flexicontent/models/category.xml

Did not test should work (of course remove [ADD] [/ADD])
Regards

Yes I understand that I'll have to take care for any update to re custom the component, but as my template is already a custom one... a little bit more...

thx for your help !

flexicontent is really a great tool

f.