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
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