Bad doctrine LIKE condition when filter have set other db field than column

[foxycode]

I have doctrine QB which I use as model:

$queryBuilder = $dao->createQueryBuilder()
    ->select('item, actuarial, customer')
    ->from(ActuarialItem::class, 'item')
    ->innerJoin('item.actuarial', 'actuarial')
    ->innerJoin('actuarial.customer', 'customer');

I am creating column like this:

$grid->addColumnText('customer', 'Customer')
    ->setColumn('actuarial.customer.bName');

$grid->addFilterText('customer', 'Customer')
    ->setColumn('customer.bName');

When I try to filter by customer, bad DQL is constructed:

SELECT item, actuarial, customer 
FROM App\Model\Entities\ActuarialItem item 
INNER JOIN item.actuarial actuarial 
INNER JOIN actuarial.customer customer 
WHERE actuarial.type = :akwm0 AND (customer.bName LIKE :vvqz0 OR actuarial.customer.bName LIKE
:vvqz1) 
ORDER BY item.actuarialItemId DESC

Filter by actuarial.customer.bName does not work. I am not sure why is OR added for column field, maybe it could be fixed by using only setted filter field?

[o5]

@foxycode: Are you sure, you pasted exactly same part of grid definition? Calling setColumn() after addColumnText() is not for filtering but for sorting.

[foxycode]

@o5 When I change setColumn on column from actuarial.customer.bName to customer.bName, it will display error right after displaying grid. And you're right about sorting, it doesn't work too on customer column.

[foxycode]

@o5 I created test from your examples here: https://github.com/foxycode/grido-examples
It gives me now another error that I have, maybe because of SQLite instead MySQL. Please look at it.

Test web is here: http://grido.liquid.sunfox.cz/inner/doctrine/?grid-sort[customer]=asc