Skip to content

Sorting does not work for numeric fields #153

@helloiamlukas

Description

@helloiamlukas

Description

When sorting numeric fields, the order of the results is not as expected.

Expected sorting order

1
3
22

Actual sorting order

1
22
3

This problem is caused by the fact that the column will be converted to a string when running the query:

order by "data"->>'number' asc

To solve this, the query should look like this (for numeric fields):

order by "data"->'number' asc

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions