This site uses cookies and similar technologies.

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

I understand
3 Posts
Ronld
2 months 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
4149 Posts
Kadministrator
2 months 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 months ago
0
Level 2

Got it. Thanks

Get a VIP membership