Custom Order not working

It's working in 3.1, but not working in 3.2 RC. So I think it may be suitable to post it here.

I set some custom order rules for custom fields in category view. It seems all rules are not working. Every rule is showing the items order by title alphabetical, no matter which rule I chose.

I confirmed that all rules I set are working in 3.1. So just wonder if the setting has to be modified in 3.2, or it's a bug.

Another question, the field I chose to order by is TEXT, but when I set the rule to order by "alpha", that rule won't show. For example:
25:alpha:desc

Field25 is a text field, but this rule not show. When I set 25:int:desc, it works. This also happened in 3.1.

I hope this helps.

Thanks,
Lomu

Hello

for start please post 2 or 3 pictures of the configurations you have set in category configuration

showing custom order and also a few parameters above and below it

Clipboard-2.jpg
I set 'Item Ordering (Level 1) CUSTOM field ordering ' to Field25 DESC INT, it works, no problem.

Clipboard-1.jpg
I choose 'Use Default Order', 'Title -- Alphabetical', 'Title -- Alphabetical Reverse', and some custom order. The Chinese words are language strings.

Clipboard-3.jpg
All order rules work, but all custom order options not work. All custom rules show same as choosing 'Title -- Alphabetical'.

The orderby in the link is like this:
&orderby=custom%3A25%3Aint%3Aasc

Clipboard-4.jpg
I set a custom order rule for field25, change int to alpha.

Clipboard-5.jpg
After the setting in clipboard-4.jpg, that custom order rule not show.

Hope the Chinese words won't confuse you.

Thanks,
Lomu

Just reminding, the custom order rule setting works well in 3.1.
Thanks,
Lomu

Hello

I can not replicate locally the reported bug

Can you also check the menu item this category view is using ?
maybe there is an override there

Also to make sure if the configuration is in effect, edit file

component/com_flexicontent/models/category.php

temporarily uncomment line 692:
makeing it
Login to frontend as a SUPER admin user and view the category
you should now see some SQL copy the printed SQL here

Hi
1. I've check the menu item, no override setting. So I think it's on category setting.
2. About the SQL query:
I set Level 1 and Level 2 Item Ordering to 'Use Global', the SQL query shows : ' ORDER BY i.created DESC, i.title ASC' (my global order setting is created DESC)

I set fronted override order to 'Title -- Alphabetical Reverse', the SQL shows: 'ORDER BY i.title DESC, i.title ASC'.

I set frontend override order to 'Published -- Most Recently first', the SQL shows: 'ORDER BY i.publish_up DESC, i.title ASC'.

I set frontend override order to the rule I set '25:int:asc', the SQL shows: 'ORDER BY i.title ASC, i.title ASC'.

Looks like there is always 'i.title ASC' in the end of line. I just upgrade to 3.2 RC today, so I think I didn't modify any code of the files. I think I do have some previous setting. If you think there is no problem of the files, I will check the other setting later.

Thanks,
Lomu