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:
...
| Section | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
As you can see, it is easy to use the custom field, you just have to get the appropriate SQL for the information that we want to display.
We can show any information that we imagine, and this is the great potential of the custom field, we just need to create a query and the custom field will take care of the rest.