How to do i sort naturally instead of alphabetically? about nestjs-paginate HOT 4 CLOSED

yeah fuck this totally.

from nestjs-paginate.

It doesn't seem like this is something that TypeORM supports out of the box.

Using the approach you linked would not work as-is:

Z
Ab 1
Ab 10

note how Z would be sorted before Ab 1 because of its length?

If you can figure out what you need using the QueryBuilder API, then you can also pass a QueryBuilder into paginate, instead of the repository.

from nestjs-paginate.

You're right. I can't find an easy way to do this properly via SQL honestly.

from nestjs-paginate.

It seems like indeed at the SQL level the world hasn't really settled onto a solution yet. Take a look at the lengths this answer tries to go: https://stackoverflow.com/a/58154535/1016004

from nestjs-paginate.