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:
...
Obtaining the sql, we created a custom field of type SQL for JIRA Progress and we insert our sql in the description of the custom field:
| Section | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
With these simple steps, we already have our custom field that measures the percentage of subtasks resolved in an issue.
| Section | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|