...
Figure 3: Advanced Form Data Binder Properties - Advanced - Aggregate Query
| Info | ||
|---|---|---|
| ||
This is a new feature in Joget Workflow v6. |
| Name | Description | ||
|---|---|---|---|
| Aggregate Fields | |||
| Group By | |||
Select field is to aggregated.
In the sample screenshot above, the "amount" field will be put into the "Sum" function. | |||
| Group By | Add grouping clause/function to the eventual data set. This can be used together with Aggregate Fields above. In the sample screenshot above, the "amount" field will be summed up by "claimant", shown in per record row. | ||
| Having Conditions | 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 | Having Conditions |