This article is for Structure Data Center.
Problem
I have a custom calculated value returned in the Formula column in my structure, and I want to see it or reference by it in Jira.
Solution
The Formula column creates a local attribute that only exists in the column’s structure. For it to be reflected in Jira, you can use an Effector: https://help.tempo.io/structure-dc/latest/effectors
The column’s value will become like any field value, and you’ll be able to see it on the Issue Page and reference it in JQL queries.
Please note:
- Since Effectors execute the bulk change action in Jira when they run, the process can potentially be resource-consuming. To allow users to have full control over when Effectors run, Effectors do not update their configured Jira fields automatically. If a change is made in the connected column, you would need to run the Effector manually again for it to rewrite the older value in the field with the new value in the column.
- however, if you want to synchronize the values between the columns and their respective Jira fields automatically, you can use a script that runs Effectors on a defined schedule: https://help.tempo.io/structure-dc/latest/run-all-effectors-by-schedule
- Effectors can write values to Jira fields from the majority of columns that can be displayed in structures.