Can't filter by "Supplier" on the "Purchase Orders" page

[nicobatty]

Bug:

Can't filter by "Supplier" on the "Purchase Orders" page.

Reproduced On:

Marello version: 1.3.0 Also on the demo: https://demo.marello.com/

Expected:

Update the list with the Supplier filter.

Actual:

Send back an error:

Data loading failed, try reloading the page. If the issue appears again please contact your administrator.

In the prod log:

[2018-03-19 18:18:39] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Query\QueryException: "[Semantical Error] line 0, col 71 near 'supplier LIKE': Error: Invalid PathExpression. Must be a StateFieldPathExpression." at /var/www/html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 63 {"exception":"[object] (Doctrine\\ORM\\Query\\QueryException(code: 0): [Semantical Error] line 0, col 71 near 'supplier LIKE': Error: Invalid PathExpression. Must be a StateFieldPathExpression. at /var/www/html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63, Doctrine\\ORM\\Query\\QueryException(code: 0): SELECT po.id FROM MarelloPurchaseOrderBundle:PurchaseOrder po WHERE po.supplier LIKE :supplier2057250939 at /var/www/html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []

[24198]

Hi @nicobatty,

Thank you for reporting! I was able to reproduce the error and I created an internal ticket for the issue. I'll let you know when this has been resolved.

Kind Regards,

Jaimy Casteleijn

[24198]

Hi @nicobatty,

A fix has been applied to the master branch and has been tagged into the 1.3.1 version of Marello (https://github.com/marellocommerce/marello/commit/916cac9ceb9f215ffdf38ea504b78b2866747617), hope this helps.

Kind Regards,

Jaimy Casteleijn