Advanced Roadmaps for Jira does not show Story Points values correctly, and does not roll up Story Points correctly
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
Advanced Roadmaps for Jira (ARJ) does not show the right values for "Story points". Values can be added in the plan, but are not reflected correctly on the Jira Issue itself.
In addition, other Story Points related functions, like "Progress (story points)" and roll-up of Story Points is not working correctly.
- Jira Server or Data Center
- Advanced Roadmaps for Jira
- The symptoms match that in the "Summary" section
When checking the database, the custom field "id" for the "Story Points" field mismatches to the field Id that ARJ uses:
-- Step 1: Obtain the custom field ID for "Story Points" SELECT id FROM customfield WHERE cfname = 'Story Points' -- Step 2: Obtain the custom field ID that ARJ uses for Story Points: SELECT propertyvalue FROM propertynumber WHERE ID IN (SELECT id FROM propertyentry WHERE PROPERTY_KEY = 'GreenHopper.StoryPoints.Default.customfield.id');
- ARJ uses the default Jira Software "Story Points" field for story points calculations, not what the linked board is configured to use
- ARJ renders the column "Story points" (with a lower case p) rather than the actual field name used for story points
- JPOSERVER-3058Getting issue details... STATUS
If applicable, you can change the Jira Software default story points field, which will result in ARJ using this field for story points calculation.
Obtain the custom field ID of the story points field you wish to use (for example, "Story Points")
SELECT id FROM customfield WHERE cfname = 'Story Points'
Obtain the ID of the
propertynumberrow needing update
SELECT id FROM propertynumber WHERE ID IN (SELECT id FROM propertyentry WHERE PROPERTY_KEY = 'GreenHopper.StoryPoints.Default.customfield.id');
propertyvaluecolumn of the
proprertynumbertable for the
IDobtained in step 2 to the custom field id obtained in step 1
UPDATE propertynumber SET propertyvalue = '<STORY POINTS CUSTOM FIELD ID FROM STEP 1>' WHERE id = <PROPERTYNUMBER ID FROM STEP 2>