orderLogic

[soluzione-software]

Hi, I have a question:
in my list there is column that show data from other table.
for sample list of sells product
customer
id
name

order
id
customer_id

product
id
order_id

in list I want to show all product sell and customer that buyed

i make:
['name'=>'order.customer.name','label'=>__('customer'),'orderable' => true],
the list show the correct field, but if I try to orders by this field it doesn't work.

why?
i try also with accessor field on product model but nothing change.

thanks

[jcastroa87]

Hi @soluzione-software,

To customize the order logic for a column in Backpack, you can use the "orderLogic" method as described in our documentation.

By adding the "orderLogic" method to your column, you can set the orderBy clause of the query as per your requirements. For example, if you want to order the results of your query in descending order based on a column called "created_at", you can add the following code to your column:

$this->addColumn([
    'name' => 'created_at',
    'label' => 'Created At',
    'type' => 'datetime',
    'orderLogic' => function ($query, $column, $direction) {
        $query->orderBy($column, 'desc');
    },
]);

In this code, the "orderLogic" method is added to the "created_at" column. The method takes three parameters: the query object, the column name, and the direction of the sort. In this case, the method sets the orderBy clause of the query to sort the results in descending order based on the "created_at" column.

Please let us know if you need any further assistance.

[soluzione-software]

thanks but if i do:
$this->addColumn([
'name' => 'order.customer.name',
'label' => 'Customer',
'type' => 'text',
'orderLogic' => function ($query, $column, $direction) {
$query->orderBy($column, 'desc');
},
]);
it doesn't work because this fields is a relation.
local.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.name desc,

how can i do?

[tabacitu]

Indeed - you need to customize the contents of that closure to match your own order logic.

[jcastroa87]

I'm closing this issue due to inactivity. If you need further assistance or have additional questions, feel free to reopen this issue or create a new one. We're here to help!