3 Posts
Ronld
2 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

Get a VIP membership
4229 Posts
Kadministrator
2 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
Ronld
2 years ago
0
Level 2

Got it. Thanks

Get a Book for SEBLOD