Skip to main content

How to adjust existing columns

The Config Builder tool allows not only create your own custom columns but also to customize existing columns to your preferred format. Common tasks include changing the data type of a column and renaming columns.

How to adjust data type of the column​

Some rarely used values could be missing from the Column Chooser and lack a predefined config, which may result in an incorrect data type. To specify a type, modify the data type of a column by creating a new config.

Navigate to Reports -> Advanced Reports -> Config Builder and click the Add New Config button. Below is an example configuration where the money data type of the qty column from the sales_invoice_item table was changed to number:

<config>
    <table name="sales_invoice_item">
        <column name="qty" label="QTY Invoiced" type="number"/>
    </table>
</config>

For detailed information about the available column types, refer to this section.

How to rename the column​

For example, to rename the Name column from the Categories table to the Category Name you need to add the next config:

<config> 
    <table name="catalog_category_entity">
        <column name="name" label="Category Name" />
    </table>
</config>

To know what exactly values should be put there, just add the column that has not been renamed yet and put the mouse cursor on the column label. Below you can see the definition of each value from the config.

After saving the config and reloading the page with the report you can see the renamed column.