We would like to add a column displaying the names of all products in an order.
We will then be able to:
To add the field to the list of available fields for your Orders grids, click on the in the 'Add a field' panel and enter the following information:
What is the field ID?: orderproductsnames
SC creates the field, you now need to populate the grid with:
Field name: Products
Table: Another table
Type: Just display
Refresh combinations: No
From the Advanced Properties panel on the right handside:
- select the menu SQLSelect and enter:
return ' , (SELECT GROUP_CONCAT(product_name SEPARATOR " ") FROM `ps_order_detail` od where od.id_order = o.id_order) as orderproductsnames ';
Exit the editing window.
The new field is now present in the list of available fields and you can add it to your Order grids.