...
| Name | Description | Screen (Click to view) |
|---|---|---|
| Group By | Add grouping clause/function to the eventual data set. This can be used together with Aggregate Fields above. In figure 3, the "amount" field will be summed up by "claimant", shown in per record row. |
Figure 3: Advanced > Aggregrate Query
Figure 4: The configurations shown in Figure 3 will produce the following sample result. |
| Aggregate Fields | This field will be displayed once any number of columns has been added into the Group By field. The select field is to aggregate.
In the sample screenshot above, the "amount" field will be put into the "Sum" function, and "Count" will be applied to "title". | |
| Having Conditions | This field will be displayed once any number of columns has been added into the Group By field. The HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause. Read more at http://www.dofactory.com/sql/having |
...
| Name | Description | Screen (Click to view) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Expression Columns | An additional column can be added in this expression columns. This is especially useful when you need to perform additional computation on multiple columns.
|
Figure 5: Advanced > Expression Columns | ||||||||||
Custom Checkbox/Radio Button Value | Define custom record ID to be used to pass over to column action. Defaulted to ID.  |
...