JSON column sorting

[keizah7]

• Laravel Version: 9.37
• Nova Version: 4.17
• PHP Version: 8.1
• Database Driver & Version: MySQL 8
• Operating System and Version: Ventura 13
• Browser type and version: Firefox 107

Description:

sortable() isn't working with spatie/laravel-translatable column:

class OrderItem extends Model
{
    use HasFactory;
    use HasTranslations;

    protected $guarded = ['id'];

    public array $translatable = ['title'];

Text::make(__('Title'), 'title')
    ->rules('required', 'max:255')
    ->sortable(),

$table->json('title');

{
  "lt": "A",
  "en": "X"
}

Column has sorting in UI, query is changing from asc to desc. but it doesn't sort the data.

Is this a bug? Because I can't pass callback to sortable method for manual order resolving, eg:

->sortable(function ($query) {
    $locale = app()->getLocale();

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

[crynobone]

1. sortable() doesn't support callable and if it does it would only be @param \Closure(\Laravel\Nova\Http\Requests\NovaRequest):bool $callback.
2. Laravel Nova uses Field::sortableUriKey() and that would be use in the orderBy query.

[nrueckmann]

We just need the ability to pass the sortableUriKey.

Example (Field.):

<?php

namespace Laravel\Nova\Fields;

 ...

abstract class Field extends FieldElement implements JsonSerializable, Resolvable
{
    ...

    private $sortableUriKey = null;

    /**
     * Specify that this field should be sortable.
     *
     * @param  bool  $value
     * @return $this
     */
    public function sortable($value = true, $sortableUriKey = null)
    {
        if (! $this->computed()) {
            $this->sortable = $value;
        }

        if ($sortableUriKey) {
            $this->sortableUriKey = $sortableUriKey;
        }

        return $this;
    }

    /**
     * Return the sortable uri key for the field.
     *
     * @return string
     */
    public function sortableUriKey()
    {
        return $this->sortableUriKey ?? $this->attribute;
    }

    ...
}