Documentation for GreenHopper 6.2.x. Documentation for other versions of JIRA Agile is available too.
GreenHopper is now called JIRA Agile. Learn more.

Skip to end of metadata
Go to start of metadata

Database tables

When you install the GreenHopper add-on into your JIRA instance, the following additional tables will be created in your JIRA database to store rank, configuration and sprint information:

  • 'AO_60DB71_COLUMN'
  • 'AO_60DB71_COLUMNSTATUS'
  • 'AO_60DB71_ESTIMATESTATISTIC'  (added around 5.9.5)
  • 'AO_60DB71_ISSUERANKING'
  • 'AO_60DB71_ISSUERANKINGLOG'
  • 'AO_60DB71_QUICKFILTER'
  • 'AO_60DB71_RANK_ISSUE_LINK'
  • 'AO_60DB71_RAPIDVIEW'
  • 'AO_60DB71_SPRINT'
  • 'AO_60DB71_STATSFIELD'
  • 'AO_60DB71_SUBQUERY'
  • 'AO_60DB71_SWIMLANE'
  • 'AO_60DB71_TRACKINGSTATISTIC'

Custom fields

If required, GreenHopper will create the following JIRA custom fields:

Custom fieldTypeNotes
Business ValueThis field is of type 'Number Field' and is available to issue types 'Story' and 'Epic'. (If you want to make it available to other issue types, edit the custom field context.) 
Epic ColourThis field is of type 'Colour of Epic' (which is a field type created by GreenHopper) and is available to the Epic issue type.

Epic Colour is the colour assigned to the epic. This is auto-assigned initially then can be changed via a dropdown on the colour box on the epic (in GreenHopper 6.0.7 and later).

This field was introduced in GreenHopper 6.0.6. It does not apply to the Classic Boards.

(info) This field is not configurable via the JIRA custom fields administration screens.

Epic NameThis field is of type 'Label of Epic' (which is a field type created by GreenHopper) and is available to the Epic issue type.

Epic Name (editable) is a short name that is used to identify an epic (see Creating an Epic).

This field was introduced in GreenHopper 6.0.6. It does not apply to the Classic Boards.

(info) This field is not configurable via the JIRA custom fields administration screens.

Epic LinkThis field is of type 'Epic Link Relationship' (which is a field type created by GreenHopper) and is available to all issue types.

Epic Link is used to determine the parent epic for an issue. This is a non-editable field; it is set by GreenHopper when you add/remove an issue to/from an epic.

Searchable via JQL.

This field was introduced in GreenHopper 6.0.6. It does not apply to the Classic Boards.

(info) This field is not configurable via the JIRA custom fields administration screens.

Epic StatusThis field is of type 'Status of Epic' (which is a field type created by GreenHopper) and is available to the Epic issue type.

Epic Status is used to exclude completed epics from being displayed in Plan mode.

This field was introduced in GreenHopper 6.0.6. It does not apply to the Classic Boards.

The Epic Status field can have one of the following values:
'ToDo' - indicates that the epic is currently open. The epic will be visible in the board.
'In Progress' - reserved for future enhancements (not used at present).
'Done' - indicates that the epic is completed. The epic will not appear in the board.

(info) This field is not configurable via the JIRA custom fields administration screens.

Epic/ThemeThis field is of type 'Label' and is available to all issue typesThis field only applies to the Classic Boards. Please see Working with Epics in GreenHopper Classic.
FlaggedThis field is of type 'Multi Checkboxes' and is available to all issue types.

See Flagging an Issue (or if you are using the Classic boards, please see Setting up a Flagging Field).

RankThis field is of type 'Global Rank' and is available to all issue types.

See also Enabling Ranking (or if you are using the Classic Planning Board then see Setting up a Ranking Field and Specifying your Project Templates).

Please ensure that your JIRA instance contains only one custom field called Rank, and that the Rank field is assigned to the global context (i.e. not to specific issues or projects).

(info) This field is not configurable via the JIRA custom fields administration screens.

Release Version HistoryThis field is of type 'GreenHopper Released Version History' and is available to all issue types. This field only applies to the Classic Boards.
SprintThis field is of type 'Sprint' and is available to all issue types.

Searchable via JQL.

This field was introduced in GreenHopper 5.8.5. It does not apply to the Classic Boards.

(info) This field is not configurable via the JIRA custom fields administration screens.

Story Points

This field is of type 'Number' and is available to issue types 'Story' and 'Epic'.

  • By default, the Story Points field is only available to issues of type 'Story' or 'Epic' (not 'Bugs' etc) — you can change this by:
    • Associating the Story Points field with other issue types (see the JIRA custom field context documentation).
    • Specifying which screens the Story Points field will be displayed on (see the JIRA documentation on Defining a Screen).
  • On the Classic Planning Board, this custom field is used in the Scrum template, or any template you configure, and can be displayed on the 'Card', 'Summary' and 'List' view; to ensure it is available when creating cards, it must be present in the Card Style.

Issue types

At installation time, GreenHopper will create the following three JIRA issue types and associate them with the Default Issue Type Scheme:

  • 'Epic'
  • 'Story'
  • 'Technical Task' (sub-task)

Issue type scheme

At installation time, GreenHopper will create a new issue type scheme called 'GreenHopper Scrum Issue Type Scheme' which contains the following issue types:

  • 'Bug'
  • 'Epic'
  • 'Improvement'
  • 'Story'
  • 'Technical Task' (sub-task)

You can add more issue types to this issue type scheme if you wish (provided you have 'JIRA Administrators' global permission).

Workflow

If you choose to create a new project when creating a board via the 'Getting Started' page, GreenHopper will give you the option of creating a new workflow called 'Simplified Workflow for Project XXX' (see Configuring Workflow), and a workflow scheme called 'Simplified Workflow Scheme for Project XXX' for your new project. This scheme is associated with all issue types.  

Note that this workflow's steps can be edited in GreenHopper (by project administrators) via a board's Columns configuration page. For more information please see Using GreenHopper Simplified Workflow.

Simplified WorkflowJIRA Workflow

Has three default steps for Scrum boards: To Do, In Progress, Done.

Has four default steps for Kanban boards: Backlog, Selected for Development, In Progress, Done.

Has more steps than are typically needed on a board (e.g. see the default JIRA workflow).
Allows issues to be dragged freely between columns.Has workflow "conditions" which prevent issues from being dragged freely between all columns.

Displays no screens on any transitions – all transitions will happen instantly.

Automatically sets a resolution of 'Done' when issues are transitioned to the desired statuses (choose the desired statuses by ticking the checkbox next to the status when configuring the board's columns).

(info) There is a known issue with this when an existing workflow is converted to the Simplified Workflow model. See this page for more info: Unable to set issues to Resolved using Greenhopper Simplified Workflow

Displays screens for Resolve Issue, Close Issue and Reopen Issue.
Can be edited from within GreenHopper (see Adding a new status on the Configuring Columns page), provided you have the 'Administer Projects' permission (for the one project that is on the board).

Can only be edited via JIRA (see Configuring Workflow), not from within GreenHopper.

Permissions

Many GreenHopper actions depend on a particular JIRA permission:

FeatureModeActionPermission LevelNotes
SprintsPlanMove sprint markerProject Admin Permission (for all projects in the backlog) 
SprintsPlanMove issue (reorder/rank)Schedule PermissionNot required if you only move issues across the sprint footer without changing the order of the issues
SprintsPlanStart sprintProject Admin Permission (for all projects where an issue is in the selection)Similar permission to creating a Version. Board ownership does not play a role here.
SprintsPlanCreate sprint

Project Admin Permission:

  • For all projects in JIRA if board does not query specific projects; or
  • For all projects queried by the board
 
SprintsPlanDelete sprint

Project Admin Permission:

  • For all projects in JIRA if board does not query specific projects; or
  • For all projects queried by the board
 
SprintsPlan/WorkAdd issue to sprintIssue Edit Permission 
SprintsPlanEdit sprint informationProject Admin Permission (for all issues in the sprint)Currently only accessible via Plan mode
SprintsWorkComplete sprintJIRA Administrator or Project Admin for all issues in the sprintCan only be done from Work mode.
SprintsWorkRemove issue from sprintEdit Issues permission 
EpicsPlanCreate epicCreate Issues permission
(Epics launched out of Labs in 6.1)
EpicsPlanRename epicEdit Issues permission
 
EpicsPlan

Rank epic

Schedule Issues permission 
EpicsPlanAdd issue to epicEdit Issues permission
 
EpicsPlanRemove issue from epicEdit Issues permission
 
VersionsPlanCreate versionProject Admin permission, or JIRA Admin permission(Versions launched out of Labe in 6.2)
VersionsPlanEdit versionProject Admin permission, or JIRA Admin permission 
VersionsPlanAdd issue to versionEdit Issues permission 
VersionsPlanRemove issue from versionEdit Issues permission
 
ConfigConfigureSimplify workflowAdministrator PermissionThe board must meet other criteria as well (see Simplified Workflow)
ConfigConfigureAdd statusProject Admin Permission (for the one project that is on the board)Project must be currently using a GreenHopper Simplified Workflow
ConfigConfigureRemove statusProject Admin Permission (for the one project that is on the board)Project must be currently using a GreenHopper Simplified Workflow
Config Create boardCreate Shared Objects global permission

People without this permission can still create boards but they will not be visible to other users of the system because their filter will not be shared.

Doesn't currently apply to Copy Board.

 

 

Sample data

On the GreenHopper "Getting Started" page you have the option of importing sample data. If you choose to do this, GreenHopper will:

  • Update the JIRA Importers add-on.
  • Import two sample projects, called "Scrum Sample" and "Kanban Sample" (you can rename these if you choose), and their issues.
  • Create a "Simplified Workflow" and a "Simplified Workflow Scheme" (see above) for each of these projects.

You may want to delete these projects, and their workflows and workflow schemes, at a later date. You can also use these scripts to import similar sample data later on.

  • No labels

1 Comment

  1. Hi,

    Does someone can tell Epic Link(Epic Link Relationship) belong to whick tables?

    Thanks