We'd like to add the 'Default category' in the product grids
To add the field to the list of available fields for your products grids, click on the in the 'Add a field' panel and enter the following information:
What is the field ID?: id_category_default
SC creates the field, you now need to populate the grid with:
Field name: ID default category
Table: Another table
Type: Just display
In the Advanced Properties panel on the right handside:
- select the menu SQL Select and enter:
return ', prs.id_category_default AS id_category_default';
Exit the editing window.
The new field is now present in the list of available fields and you can add it to your product grids.