The SQL for JIRA Progress Custom Field is a convenient way to show percentage values as well as a label beside 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:
...
We may be interested to know what percentage of the subtasks have been performed. This can be achieved with "Progress Bar" custom field.
The first step is to get the query to get the parameters' label, 'value' and 'grill' that our custom field needs, and for this we help from the add-on SQL for JIRA Driver.
...