Filter by product bought in Order list (BO)

[petiteetoilee]

Hello,

I'd like to modify the ORDER LIST page in the backoffice (version ( 1.7.8.7), as I had done on my previous site (with an override) (version 1.6), to replace the REFERENCES column by the list of products purchased by the customer, with a field allowing orders to be filtered by products purchased.

Of course, I know that you can see the list of products purchased at a glance by scrolling down the order with the little arrow, but this doesn't allow you to use the FILTER function on all products sold. This option is very important to me.

I was able to change the column name in shop/src/Core/Grid/Definition/Factory/OrderGridDefinitionFactory.php
but I'm completely lost with the multitude of files and folders in the new version and what line of code to add (and where).

(At the time, I had added this line of code in AdminOrderController.php on my previous site, as you can see it worked perfectly)

 (SELECT GROUP_CONCAT(odd.product_name SEPARATOR ", ") FROM `'._DB_PREFIX_.'order_detail` odd WHERE odd.id_order = a.id_order) as products,

To make things clearer, here are some screenshots (of my old site and the new one)
 

Thanks in advance for your help!