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:
...
| Warning | ||
|---|---|---|
| ||
As can be seen, the query of the image has been made for a particular issue, in this case the issue with identifier 10201. But we want to calculate the percentage for the issue that is being displayed in JIRA at that time. Therefore, we need to take the key of the issue as a variable. For this, we replace the identifier 10201 with the expression ${key}. The add-on is smart enough to replace the value of the expression with the identifier of the issue being displayed. |
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 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
