List Manager Forum

Sorting foreign characters in auto-filter select

User bonnielass 2018-02-22 15:10:41

My list is in Swedish and we have the characters ÅÄÖ. In auto-filter select list the characters are ordered as AAO. How can I make the list order correctly according to Swedish standard?

Moonsoft support 2018-02-23 09:57:34

Hi,
can you please specify which type did you use for that column/field? Is a free text field where users type or any other type like sql or manual list configured by you? We'll reproduce here and let you know how to fix.

Thanks, regards

User bonnielass 2018-02-23 14:50:11

The select list in the filter module is generated from a type text field. Thanks!

User bonnielass 2018-02-26 10:21:00

I also have a filter field type number that sorts incorrectly. I have numbers 1-14 and the select list sorts 1, 10,11,12,13,14,2,3,4. Do I need to add leading zero to all one digit values or can I make it work another way?

Moonsoft support 2018-02-26 12:11:38

Hi,

We made some tests and seems to be working. Can you please place a private ticket at Helpdesk sharing a url and administrator credentials?

Thanks. Regards,

User bonnielass 2018-02-27 10:04:01

Thanks for your trouble. However I solved the issue. I changed the collate on the field value in #__listmanager_values to utf8_swedish_ci and that did the trick.

Moonsoft support 2018-02-27 10:10:59

Hi,
perfect, great it worked. Thank you very much for sharing!
Regards

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!