EasyAdminBundle
EasyAdminBundle copied to clipboard
refactor(search): Nested properties
Update the query builder logic to correctly apply aliases for all levels of nested joins.
Before (incorrect):
SELECT o
FROM App\Entity\Order o
LEFT JOIN o.orderItem oi
LEFT JOIN oi.reservation r1
LEFT JOIN r.product p2
LEFT JOIN p.manufacturer m3
LEFT JOIN m.orders o4
WHERE LOWER(CONCAT(o4.reference, '')) LIKE :query_for_text_1
ORDER BY o.createdAt DESC
After
SELECT o
FROM App\Entity\Order o
LEFT JOIN o.orderItem oi
LEFT JOIN oi.reservation r1
LEFT JOIN r1.product p2
LEFT JOIN p2.manufacturer m3
LEFT JOIN m3.orders o4
WHERE LOWER(CONCAT(o4.reference, '')) LIKE :query_for_text_1
ORDER BY o.createdAt DESC
related #6409