Edit Column Settings

After you have added the tables and selected the required columns, you can change settings for each column in the “Grid” pane:

The following settings are available for each column:

• Column – the possibility to select the required column from the combo box or add a new column. If necessary, you can customize the column expression. To do this, click the elision marks button for the respective column and specify an expression in the “Expression Editor” pop-up window;
• Table – the corresponding table names are displayed;
• Alias – the possibility to specify the column alias;
• Output – whether or not to display the columns in the query;
• Sorting Type – the possibility to specify the sort order for column values;
• Sort Order – the possibility to specify the order in which several columns are sorted;
• Group By – used in conjunction with the aggregate functions to group the result-set by one or more columns;
• Aggregate – allows to specify the aggregated function used to aggregate column