JIRA Agile - JIRA Configuration
Database tables
When you install the JIRA Agile 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, JIRA Agile will create the following JIRA custom fields:
Custom field | Type | Notes |
---|---|---|
Business Value | This 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 Colour | This field is of type 'Colour of Epic' (which is a field type created by JIRA Agile) 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. This field is not configurable via the JIRA custom fields administration screens. |
Epic Name | This field is of type 'Label of Epic' (which is a field type created by JIRA Agile) 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 is not configurable via the JIRA custom fields administration screens. |
Epic Link | This field is of type 'Epic Link Relationship' (which is a field type created by JIRA Agile) 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 JIRA Agile when you add/remove an issue to/from an epic. Searchable via JQL. This field is not configurable via the JIRA custom fields administration screens. |
Epic Status | This field is of type 'Status of Epic' (which is a field type created by JIRA Agile) and is available to the Epic issue type. | Epic Status is used to exclude completed epics from being displayed in the Backlog. The Epic Status field can have one of the following values: This field is not configurable via the JIRA custom fields administration screens. |
Flagged | This field is of type 'Multi Checkboxes' and is available to all issue types. | See Flagging an Issue. |
Rank | This field is of type 'Global Rank' and is available to all issue types. | See also Enabling Ranking. 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). This field is not configurable via the JIRA custom fields administration screens. |
Sprint | This field is of type 'Sprint' and is available to all issue types. | Searchable via JQL. 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'. |
|
Issue types
When the first JIRA Agile project (Scrum or Kanban) is created in JIRA, JIRA Agile 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
When the first JIRA Agile project (Scrum or Kanban) is created in JIRA, JIRA Agile will create a new issue type scheme called 'JIRA Agile 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, JIRA Agile 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 JIRA Agile (by project administrators) via a board's Columns configuration page. For more information please see Using JIRA Agile Simplified Workflow.
Simplified Workflow | JIRA Workflow |
---|---|
|
|
|
|
|
|
|
|
Permissions
Many JIRA Agile actions depend on a particular JIRA permission:
Feature | Screen | Action | Permission Level | Notes |
---|---|---|---|---|
Sprints | Backlog | Move sprint marker | Project Admin permission (for all projects in the backlog) | |
Sprints | Backlog | Move issue (reorder/rank) | Schedule Issues permission and Edit Issues permission | Not required if you only move issues across the sprint footer without changing the order of the issues |
Sprints | Backlog | Start sprint | Project 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. |
Sprints | Backlog | Create sprint | Project Admin permission:
| |
Sprints | Backlog | Delete sprint | Project Admin permission:
| |
Sprints | Backlog & Active sprints | Add issue to sprint | Schedule Issues permission and Edit Issues permission | |
Sprints | Backlog | Edit sprint information | Project Admin permission (for all issues in the sprint) | Can only be done from the Backlog. |
Sprints | Backlog | Reorder sprint | Project Admin permission (for all issues in the sprint) | |
Sprints | Active sprints | Complete sprint | JIRA Administrator or Project Admin for all issues in the sprint | Can only be done from the Active sprints. |
Sprints | Active sprints | Remove issue from sprint | Schedule Issues permission and Edit Issues permission | |
Epics | Backlog | Create epic | Create Issues permission | |
Epics | Backlog | Rename epic | Edit Issues permission | |
Epics | Backlog | Rank epic | Schedule Issues permission | |
Epics | Backlog | Add issue to epic | Edit Issues permission | |
Epics | Backlog | Remove issue from epic | Edit Issues permission | |
Versions | Backlog | Create version | Project Admin permission, or JIRA Admin permission | (Versions launched out of Labe in 6.2) |
Versions | Backlog | Edit version | Project Admin permission, or JIRA Admin permission | |
Versions | Backlog | Add issue to version | Edit Issues permission | |
Versions | Backlog | Remove issue from version | Edit Issues permission | |
Config | Configure | Simplify workflow | Administrator permission | The board must meet other criteria as well (see Simplified Workflow) |
Config | Configure | Add status | Project Admin permission (for the one project that is on the board) | Project must be currently using an Agile Simplified Workflow |
Config | Configure | Remove status | Project Admin permission (for the one project that is on the board) | Project must be currently using an Agile Simplified Workflow |
Config | Create board | Create 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 JIRA Agile "Getting Started" page you have the option of importing sample data. If you choose to do this, JIRA Agile 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.