ordering rank(id) based on another column value

[Ahmed-Elrayes]

Hello, i wanna ask a little question
how to make ranking (id, the first column) based on another column value

as example in this picture i'm ordering by "Rank" and it's ASC ordering while the ItemPoints is ordered DESC

but if i click on ItemPoints to Order by it the Rank column is getting disordered because there are many columns with the same value inside ItemPoints as you can see in this picture,

so is there a way to connect these two columns with each others to show the same result?

PS: i'm using HTML Builder with Columns

and that's the columns code

/**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {
        return [
            Column::make('id')
                ->name('id')
                ->title(__('ranking.table.rank'))
                ->footer(__('ranking.table.rank'))
                ->visible(true)
                ->orderable(true)
                ->width(60),
            Column::make('char')
                ->name('char')
                ->title(__('ranking.table.charname'))
                ->footer(__('ranking.table.charname'))
                ->visible(true)
                ->width(150)
                ->orderable(true),
            Column::make('guild')
                ->name('guild')
                ->title(__('ranking.table.guild'))
                ->footer(__('ranking.table.guild'))
                ->visible(true)
                ->orderable(true),
            Column::make('CurLevel')
                ->name('CurLevel')
                ->title(__('ranking.table.level'))
                ->footer(__('ranking.table.level'))
                ->visible(true)
                ->orderable(true),

            Column::make('ItemPoints')
                ->name('ItemPoints')
                ->title(__('ranking.table.itempoints'))
                ->footer(__('ranking.table.itempoints'))
                ->visible(true)
                ->orderable(true),
        ];
    }

Thanks

[yajra]

Just do a multiple column ordering?

->order([
  [4, 'desc'],
  [0, 'asc']
])

[Ahmed-Elrayes]

That's my builder data right now, but still not working after i added the order as you suggested.
PS: that's another DataTable need to connect two columns with each others.
but the issue in this one is that the value query isn't ordered from the query itself, because it's using a helper to do some collecting .

return $this->builder()
            ->columns($this->getColumns())
            ->minifiedAjax()
            ->parameters([
                'dom' => 'Bfrltip',
                'order' => [
                    [0, 'ASC'],
                    [2, 'DESC'],
                ],
                'orderable' => true,
                'responsive' => true,
                "processing" => true,
                "info" => true,
                "searching" => true,
                'select' => false,
                "lengthMenu" => [[10, 25, 50, 100, 200, -1], [10, 25, 50, 100, 200, __('datatables.show-all')]],
                'language' => [
                    'search' => __('datatables.search'),
                    'zeroRecords' => __('datatables.zero'),
                    "info" => __('datatables.info'),
                    "infoEmpty" => __('datatables.empty'),
                    "infoFiltered" => __('datatables.info-filtered'),
                    "paginate" => [
                        "first" => __('datatables.first'),
                        "last" => __('datatables.last'),
                        "next" => ">",
                        "previous" => "<"
                    ],
                    'searchPlaceholder' => __('datatables.searchPlaceholder'),
                    'lengthMenu' => __('datatables.length'),
                    'processing' => __('datatables.processing'),
                ],
                'buttons' => [
                    'reload',
                    'print',
                    'colvis',
                ],
            ]);

[yajra]

Just note that you must convert all your ordering via SQL If the value is computed outside the query, then I think it's impossible to sort on both columns.

You can try using collection and sorting of computed column would work. However, do note that it is prone to performance issue when your dataset is large.

[Ahmed-Elrayes]

i did it as collection but i had to disable the ordering from the third column (it's number 2) because i will missorder if there are 2 cols with the same value