EasyAdminBundle icon indicating copy to clipboard operation
EasyAdminBundle copied to clipboard

refactor(search): Nested properties

Open tpatartmajeur opened this issue 6 months ago • 0 comments

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

tpatartmajeur avatar Aug 16 '24 07:08 tpatartmajeur