Can the ActiveDataProvider be configured to sort by the string length of a particular field?

Question

Yii

I use GridView together with ActiveDataProvider. When displaying a table, it is necessary to configure sorting: by the length of the strings of values ​​of a certain field.

$dataProvider = new ActiveDataProvider([
            'query' => $query,
            'sort' => [
                'defaultOrder' => [
                    'name' => ???
                ]
            ]
        ]);

Those. values ​​for example with '11' must be displayed before '111', because line length is shorter here. I hope I explained clearly)

Answer 1

something like this

$dataProvider->sort->attributes['name'] = [
    'asc' => [
        'LENGTH(name)' => SORT_ASC
    ],
    'desc' => [
        'LENGTH(name)' => SORT_DESC
    ],
];

PS the code is written on the knee, but dig in this direction