[Question] orderBy() with natural sorting

[roman-briazgalov]

Hi!
First of all thank you very much for this library! It's really useful and convenient!
I cannot understand one thing: how should i use orderBy().
So my query is here:

return (new Elements())
            ->newQuery()
            ->where('user_id', $user_id)
            ->where('child', false)
            ->where('in_trash', false)
            ->orderBy('title')
            ->paginate(10);

The result of this query is:

12312123
AZaz
WQER
ZXC
az
test
zxc

As you can see the sorting is not 'natural'.

I need to make the query that would return this items with this order:

12312123
AZaz
az
test
WQER
ZXC
zxc

I studied in detail this issue #148
But anything i have tried didn't help me.

I would be really appreciated if you tell me how can could i make the needed sorting.

[galzetta]

Correct me if I'm wrong @jenssegers The natural order of #148 is nothing else but what mongodb calls natural order:https://docs.mongodb.com/manual/reference/glossary/#term-natural-order i.e. the order of the elements on disk.

It has nothing to do with natural sort order.

Now the question is: how do we obtain natural sort order? Should we just use the collation for this: https://tkacz.pro/mongodb-natural-sort/ (including setting the caseFirst and caseLevel options?)

[kokilson]

Order BY sorting is not being worked. I am using power grid table with livewire. In my case sorting is working for few columns not for all columns.

return Order::where('status', $this->filter)
->orderBy('customer_name')
->paginate(10);