This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
3 Posts
Ronld
5 days ago
Topic

Hey


The Subject is telling everything. My problem: I've a numeric article list which orders my numbers like 1, 11, 12, 2.

This field should order by number or text (depending on the selection in the frontend).


My settings for the field:


Type: Ordering

Mode: Numeric

Direction: ASC

Variation: Filter


I'm sorry if I've missed the solution in the forum but it's really hard to filter.


Ronld

Get a VIP membership
4058 Posts
Klasadministrator
2 days ago
1
Level 1

This comes from mysql, you obviously have this database column formated as string, you need to change it to the appropriate numeric format like INT. You can do this directly in the database or in he field setting if you click on Chage checkbox next to storage settings.

3 Posts
Ronld
2 days ago
0
Level 2

Got it. Thanks

Get a VIP membership