...
| 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
|
 |
...
| Name | Description |
|---|
Userview Key Name | When defined, additional condition will be appended using the value defined here as the parameter and the userview key value as the value. | Info |
|---|
| SQL: SELECT category, count(category) FROM table1 Userview Key Name: type Userview Key Value: val Resultant SQL: SELECT category, count(category) FROM table1 WHERE type = 'val' |
When userview key value is defined, you may define #userviewKey# in your SQL query to have it replaced with the userview key value. | Info |
|---|
| SQL: SELECT category, count(category) FROM table1 WHERE type = '#userviewKey#' Userview Key Value: val Resultant SQL: SELECT category, count(category) FROM table1 WHERE type = 'val' |
|
| Custom Header in HTML. |
| Custom Footer in HTML. |
Interactive Chart
The following code can be modified and put in "Custom Footer" for interactive Chart.
...