ordering

[keizah7]

How I can order by translatable column using eloquent without harcoding locale?

$locale = 'en';

$query->orderBy('attribute_title->' . $locale);

[salvisb]

From the Laravel docs https://laravel.com/docs/9.x/localization#determining-the-current-locale

`
use Illuminate\Support\Facades\App;

$locale = App::currentLocale();
`

[keizah7]

Thanks, I know how get locale, I'm searching for way to order without providing it.

[michaelravedoni]

Hello @keizah7,
I suggest to use the Laravel collection method sortBy(). For example :

$queryData = $query->get(); // or Model::get();
$collectionSorted = $queryData->sortBy(function($item, $key){
    return $item->attribute_title;
});
$sorted = $collectionSorted->values();

I hope it can help you.

[keizah7]

Hello, I am using this query in Laravel Nova indexQuery, as you maybe know, that method should return query, so collection helpers is not usable in this case

[michaelravedoni]

Hello, oh okay. I can't help you more then. I have no experience with Laravel Nova. But since a query refers to columns, maybe it is possible to do something with a virtualAs() column in the migration file?