Disable sorting data

[fooino]

Livewire PowerGrid version

v6.5

Livewire version

v3.6

Laravel version

v12.24

Which PHP version are you using?

PHP 8.3

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

Yes

What is the problem?

The package sorts data based on

    public string $sortField = 'id';

    public string $sortDirection = 'asc';

and does not care about the query that fetched data from the database

In Laravel I use a package in my vendor to fetch languages. The query order by is not simple, and there are some conditions in the query

select
  *
from
  `languages`
where
  `languages`.`deleted_at` is null
order by
  CASE
    WHEN `state` = 'DEFAULT' THEN 1
    WHEN `state` = 'NON_DEFAULT' THEN 0
  END DESC,
  CASE
    WHEN `status` = 'ACTIVE' THEN 1
    WHEN `status` = 'INACTIVE' THEN 0
  END DESC,
  `languages`.`priority` asc,
  `languages`.`id` asc

If the status, state of languages are same, the query sorts the data based on priority

But in this picture, the data sorted by id by the powergrid package

I think the package must not sorting data by default or if there is a boolean property that disables or enables the sorting

Code snippets

final class Archive extends AdminTableComponent
{
    public string $tableName = 'language-archive-e91uos-table';

    public function datasource(): Collection
    {
    dd(app(GetPaginatedLanguagesAction::class)->run()->pluck('priority' , 'name')->toArray()); // the result data sorted by my query conditions
        return app(GetPaginatedLanguagesAction::class)->run();
    }
}    

How do you expect it to work?

enable or disable the sorting by id or not sorting at all

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.

[luanfreitasdev]

Hello. Do you try to clear the sortField property?

See: https://github.com/Power-Components/livewire-powergrid/blob/6.x/src/DataSource/Processors/Database/Pipelines/Sorting.php#L22