[Bug]: Ordering by field in Datasource doesnt let you Sort with it

[BenOussama180]

Have you searched through other issues to see if your problem is already reported or has been fixed?

No

Did you read the documentation?

Yes, I did not find it.

Have you tried to publish the views?

Yes - I didn't work.

Is there an error in the console?

No

PowerGrid

3.5.13

Laravel

9.x

Livewire

v2.10.5

Alpine JS

3

Theme

Tailwind 3.x, Tailwind 3.x with tailwind/forms

Describe the bug.

when you order with a field in datasource for example ->orderBy('price', 'asc') u can not sort with it in the columns() function with the ->sortable() , the sort doesnt change

To Reproduce...

data source: return Link::whereShowToCustomers(1) ->with('orders', 'orders.projects') ->orderBy('price', 'asc') ->groupBy('site');
column : Column::add() ->title('Price') ->field('price_formatted', 'price') ->searchable() ->sortable() ->makeInputRange() ->bodyAttribute('text-center', '') ->headerAttribute('text-center', ''),

Extra information

<?php
 //...

[luanfreitasdev]

I think you shouldn't use orderBy in datasource, try using $sortField and $sortDirection properties

https://livewire-powergrid.com/table/component-settings.html#sort-by-field-and-direction

[BenOussama180]

but i have to sort the data before grouping, so it'll only take the cheapest link out of duplicates by site ,
any work around ? @luanfreitasdev thanks in advanced

[luanfreitasdev]

If groupBy is inside the powergrid component would it work?

[BenOussama180]

how can put the groupby inside powergrid component? @luanfreitasdev

[luanfreitasdev]

how can put the groupby inside powergrid component? @luanfreitasdev

after orderBy
https://github.com/Power-Components/livewire-powergrid/blob/main/src/PowerGridComponent.php#L260

[BenOussama180]

hmm i will try that! thank you

[luanfreitasdev]

Hello!. I'll move this up for discussion as it's not a bug initially. We can see this as an improvement.