The SQL for JIRA Progress Custom Field is a convenient way to show percentage values as well as a label beside the bar.
The SQL for JIRA query have to return some specific columns in order to configure the bar:
- Value: a decimal number between 0 and 1. It represents the progress.
- Label: A free text shown on the right of the bar
- Fill: The colors representing the progress.
Example:
select '33.3%' as "label", 0.333 as "value", '{gradient:["green", "yellow", "red"]}' as fill
from issues i where i.key=?
The fill column is quite customizable with solid colors as well as gradients. Examples:
{ color: "#ff1e41" }{ color: 'rgba(255, 255, 255, .3)' }{ gradient: ["red", "green", "blue"] }{ gradient: [["red", .2], ["green", .3], ["blue", .8]] }{ gradient: [ ... ], gradientAngle: Math.PI / 4 }{ gradient: [ ... ], gradientDirection: [x0, y0, x1, y1] }
Default: { gradient: ["#3aeabb", "#fdd250"] }