3 Posts
5 years 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
4229 Posts
5 years 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
5 years ago
0
Level 2
Got it. Thanks