To create a support ticket, start a search

Customer Interface: ID Groups field


Target

We would like to add a column displaying all ID groups associatd to customers in the Customer interface.

 

Setup

To add the field to the list of available fields for your grids, click on the in the 'Add a field' panel and enter the following information:

What is the field ID?: group_id

 

Sc creates the field, you now need to populate the grid with:

Field name: Group ID
Table: Another table
Type: only display

 

From the Advanced Properties panel on the right handside:

- select the menu SQL Select and enter:

return ' , (SELECT GROUP_CONCAT(cst_cg.id_group)
FROM `'._DB_PREFIX_.'customer_group` cst_cg
    WHERE cst_cg.id_customer = c.id_customer ) AS group_id ';

 

Exit the editing window.

The new field is now present in the list of available fields and you can add it to your Customer grids.
 




Related articles