Mastering JIRA

Book Image

Mastering JIRA

By : Ravi Sagar

Book Image

Mastering JIRA

By: Ravi Sagar

Overview of this book

<p>JIRA is an issue-tracking tool from Atlassian and has gained immense popularity in recent years due to its ease of use and, at the same time, its customization abilities and finely grained control over various functions. JIRA offers functionalities for creating tasks and assigning them to users and many useful add-ons can be added such as JIRA Agile for Agile tracking and Groovy scripts, a powerful tool for administering customizations for customizations.</p> <p>This book explains how to master the key functionalities of JIRA and its customizations and add-ons, and is packed with real-world examples and use cases. You will first learn how to plan JIRA installation. Next, you will be given a brief refresher of fundamental concepts and learn about customizations in detail. Next, this book will take you through add-on development to extend JIRA functionality. Finally, this book will explore best practices and troubleshooting, to help you find out what went wrong and how to fix it.</p>

Mastering JIRA

Credits

About the Author

About the Author

About the Reviewer

About the Reviewer

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Planning Your JIRA Installation

Planning Your JIRA Installation

Planning the installation

System requirements

Setting up the MySQL database

The JIRA setup wizard

JIRA Directory structure, startup/shutdown scripts, and log files

Planning your upgrade

Updating JIRA add-ons

Applications, uses, and examples

JIRA core concepts

Searching in JIRA

Searching in JIRA

The Issue Navigator window

Searching the issues

Filters and subscriptions

An introduction to JQL

Browser shortcuts

Exporting issues in Excel, RSS, and XML

Reporting – Charts to Visualize the Data

Reporting – Charts to Visualize the Data

Project reports

Gadgets for reporting purposes

Using add-on charts to visualize data

Customizing JIRA for Test Management

Customizing JIRA for Test Management

What is test management?

Creating Issue Types for test campaign and test cases

Customizing the workflow for a change in transitions

Capturing additional data from a user on state transitions

Learn how to make certain fields mandatory only for test case

Limiting the project visibility to certain group and individuals

Learn how to hide a specific issue from the user within a project

Versions and components

Sample Implementation of Use Cases

Sample Implementation of Use Cases

Gathering the requirements

Preparing the JIRA configuration document

Setting up JIRA for helpdesk/support tickets

Setting up JIRA for requirement management

Setting up JIRA for bug tracking

Changes in the customizations

User Management, Groups, and Project Roles

User Management, Groups, and Project Roles

User and group management

Working with project roles

Types of administrators

Configuring JIRA User Directories to Connect with LDAP, Crowd, and JIRA User Server

Configuring JIRA User Directories to Connect with LDAP, Crowd, and JIRA User Server

The authentication mechanism in JIRA

Allowing other applications to connect to JIRA

Synchronizing user and group information

JIRA Add-on Development and Leveraging REST API

JIRA Add-on Development and Leveraging REST API

Setting up the Atlassian plugin SDK

Installing the Atlassian SDK on Windows

Creating the Helloworld plugin

Setting up the Eclipse IDE

Leveraging the JIRA REST API

Importing and Exporting Data in JIRA

Importing and Exporting Data in JIRA

The Backup System

The Restore System utility

The Project Import utility

External system import using CSV

Working with JIRA Agile

Working with JIRA Agile

Product overview – what is JIRA Agile?

Managing multiple teams and projects using boards

JIRA Administration with Groovy Script Runner

JIRA Administration with Groovy Script Runner

Installing Script Runner

Built-in scripts for administration

Modifying the JIRA workflow with conditions, validators, and post functions

Accessing powerful JQL functions

Accessing the Database

Accessing the Database

JIRA's database schema

Accessing MySQL

Accessing PostgreSQL

The jiraissue table

The customfield table

The customfieldvalue table

Some useful SQL queries

Customizing Look and Feel and Behavior

Customizing Look and Feel and Behavior

How to add your own CSS

Adding JavaScript to show/hide a field

Velocity templates

JIRA Best Practices

JIRA Best Practices

A note of caution before modifying default schemes and configurations

The JIRA customization process

Using the project context to assign different options in multiple projects

Creating too many custom fields – a factor in slow performance

Choosing a custom field type wisely

Defining permissions

JIRA's Audit Log

Adding the Announcement Banner

Adding an introduction

Performing indexing from time to time

Troubleshooting JIRA

Troubleshooting JIRA

Atlassian support

Common configuration issues

Increasing memory

Integrity Checker

Integrating JIRA with Other Tools

Integrating JIRA with Other Tools

JIRA with the Subversion plugin

JIRA with Bitbucket and GitHub

JIRA with other Git repositories

JIRA with Confluence

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Accessing MySQL

The HSQLDB database manager should never be used in the production instance because it's prone to data loss. The recommended database is either MySQL or PostgreSQL. Earlier in this book, we have discussed how to create a database in MySQL to store JIRA's data and configure it during the setup phase. To access your database in order to run SQL queries, you can either use the MySQL console, which comes with the MySQL server, or you can use phpMyAdmin.

phpMyAdmin

The phpMyAdmin application can be downloaded from http://www.phpmyadmin.net/.

This is a great web-based tool to manage your MySQL database and it's usually accessed using http://localhost/phpmyadmin/. The exact URL can be different based on your installation.

Perform these steps:

Open the previous URL in your browser to launch phpMyAdmin:
You will notice that the list of databases appear on the left-hand side. Our jiradb database also appears in this list. We created this database for our JIRA instance.
Click on the plus ...