Skip to content

[5.x]: Ordering by number still not fixed when using twig queries. #15973

@leonwebcreators

Description

@leonwebcreators

What happened?
When ordering by a number field, the resulted order will be:
6
32
31
30
29
[...]

This query will result in the above wrong ordered list:
{% set entries = craft.entries().search('keyword').orderBy('number desc').all() %}

Ordering with another param works:
{% set entries = craft.entries().search('keyword').orderBy('weblink desc').all() %}

Expected behavior
Able to order by number in Twig

Actual behavior
Errors as above

Craft CMS version
5.4.9

PHP version
8.3

Operating system and version
No response

Database type and version
PostgreSQL 13/14/15/16

Image driver and version
No response

Installed plugins and versions
No response

Related errors (but this one was backend-only)
#15417

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions