If a user has deleted the original Epic issue type, and deleted all other issue types above Issue ID 6 and then creates a new Issue type (for example Sub Task) so that it has Issue ID 6, Greenhopper will use that new issuetype as the Epic issue type.
This causes all issues with Issue ID 6 (in the example: subtasks) to appear on the Epic listing on the left of the Scrum board. Even if the user has created a new Epic issue type.
Adding the feature to select which Issue ID is associated with would help resolve this, as to at the moment an SQL query has to be run to change the epic Issue ID.
- Backup the instance to XML.
- Install the XML into a test instance.
- Add any missing Issue Types, such as the Epic, Story & Technical Task (this is actually a sub-task) through the browser GUI.
- Execute the following SQL to identify their IDs in the database:
Keep track of these as we'll need them later.
- Add a Story Points Custom Field (Number Field), ensuring to set the context to Epic and Story.
- Add it to the appropriate screens (e.g.: default, however this depends upon JIRA's configuration).
- Use the below SQL to identify the ID:
- Execute the following SQL to get your GreenHopper property map:
- Replace the map with the appropriate Story Points Custom Field and Epic, Story & Technical Task Issue Type. For example:
Make sure not to include any comments, these are just for reference.
- Stop JIRA.
- Update the map after making the correct changes with the following:
- Start JIRA.
- Install the GreenHopper plugin and reindex JIRA.
- Test by creating a new board and verify all is working.