| Panel |
|---|
| borderColor | green |
|---|
| borderWidth | 1 |
|---|
| titleBGColor | #ddffcc |
|---|
| borderStyle | solid |
|---|
| title | Definition |
|---|
|
SQL Chart allows you to define your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types. |
Image Removed
Image Added
Figure 1: SQL Chart Properties
...
| Name | Description |
|---|
| Datasource | - Using Data Binder
- Default Datasource
- Custom Datasource
| Panel |
|---|
| borderColor | purple |
|---|
| borderWidth | 1 |
|---|
| titleBGColor | #ddccff |
|---|
| borderStyle | solid |
|---|
| title | New Feature |
|---|
| New feature in Joget Workflow for more flexible ways to build chart dataset using the existing Datalist Binders. |
|
| Data Binder | When Datasource is set to "Using Data Binder", this option will show up. Please see Datalist Binder for available binder to use. |
| SQL Query | When Datasource is set to use any of the "Datasource", this option will show up. SQL Query to produce the dataset required for the graph type. | Info |
|---|
The first column in the dataset will be assumed for X-axis/label. |
The first column to be returned from the query must be a label (X-axis), followed by value columns for the Y-axis. Example 1: | Code Block |
|---|
| SELECT c_status as 'status', COUNT(c_status) as 'count' FROM app_fd_tix_tickets WHERE c_status IS NOT NULL GROUP BY c_status |
Example 2: | Code Block |
|---|
| select c.c_claimant, sum( cast( replace(c.c_total,'$', '') as decimal(10,2)) ) as 'total', avg( cast( replace(c.c_total,'$', '') as decimal(10,2)) ) as 'avg' from app_fd_hr_expense_claim c group by c.c_claimant
|
 |
...