Mastering JIRA 7 - Second Edition

Book Image

Mastering JIRA 7 - Second Edition

By : Ravi Sagar

Book Image

Mastering JIRA 7 - Second Edition

By: Ravi Sagar

Overview of this book

Atlassian JIRA 7 is an enterprise issue tracker system. One of its key strengths is its ability to adapt to the needs of an organization, ranging from building software products to managing your support issues. This book provides a comprehensive explanation covering all three components of JIRA 7, such as JIRA Software, JIRA Core, and Jira Service Desk. It shows you how to master the key functionalities of JIRA and its customizations and useful add-ons, and is packed with real-world examples and use cases. You will first learn how to plan for a JIRA 7 installation and fetch data. We cover JIRA reports in detail, which will help you analyze your data effectively. You can add additional features to your JIRA application by choosing one of the already built-in add-ons or building a new one to suit your needs. Then you'll find out about implementing Agile methodologies in JIRA by creating Scrum and Kanban boards. We'll teach you how to integrate your JIRA Application with other tools such as Confluence, SVN, Git, and more, which will help you extend your application. Finally, we'll explore best practices and troubleshooting techniques to help you find out what went wrong and understand how to fix it.

Mastering JIRA 7 - Second Edition

Mastering JIRA 7 - Second Edition

Credits

About the Author

About the Author

Acknowledgements

Acknowledgements

About the Reviewer

About the Reviewer

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Planning Your JIRA Installation

Planning Your JIRA Installation

What is new in JIRA 7?

Planning your JIRA 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

Introduction to JQL

Browser shortcuts

Exporting issues in Excel, RSS, XML, and JSON

Reporting – Using Charts to Visualize the Data

Reporting – Using Charts to Visualize the Data

Project reports

Configuring and sharing dashboards

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 campaigns and test cases

Customizing the workflow for changes in transitions

Capturing additional data from users on state transitions

Learning how to make certain fields mandatory only for a test campaign

Limiting the project visibility to certain groups and individuals

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

Versions and components

Understanding Zephyr and its Features

Understanding Zephyr and its Features

Installing the Zephyr plugin

Zephyr terminology

Starting to use Zephyr

Sample Implementation of Use Cases

Sample Implementation of Use Cases

Gathering 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

Authentication mechanism in JIRA

Allowing other applications to connect to JIRA

Synchronizing user and group information

JIRA Add-On Development and Leveraging the REST API

JIRA Add-On Development and Leveraging the 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 and Migrating Configuration

Importing and Exporting Data in JIRA and Migrating Configuration

The backup system

Restoring the system utility

Project Import utility

External system import using CSV

Migrate JIRA configurations using the Configuration Manager add-on

Working with Agile Boards in JIRA Software

Working with Agile Boards in JIRA Software

Product overview – JIRA Software

Managing multiple teams and projects using boards

JIRA Administration with ScriptRunner and the CLI Add-on

JIRA Administration with ScriptRunner and the CLI Add-on

Installing ScriptRunner

Installing JIRA CLI

Database Access

Database Access

JIRA's database schema

Accessing MySQL

Accessing PostgreSQL

The jiraissue table

The customfield table

The customfieldvalue table

Some useful SQL queries

Customizing Look, Feel, and Behavior

Customizing Look, Feel, and Behavior

Adding your own CSS

Adding JavaScript to show/hide field

Velocity templates

Implementing JIRA Service Desk

Implementing JIRA Service Desk

Product overview – JIRA Service Desk?

Installing JIRA Service Desk

Integrating JIRA with Common Atlassian Applications and Other Tools

Integrating JIRA with Common Atlassian Applications and Other Tools

JIRA with the Subversion plugin

JIRA with Bitbucket and GitHub

JIRA with other Git repositories

JIRA with Confluence

JIRA Best Practices

JIRA Best Practices

A word of caution before modifying default schemes and configurations

The JIRA customization process

Using 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 regular indexing

Troubleshooting JIRA

Troubleshooting JIRA

Atlassian support

Common configuration issues

Increasing memory

Integrity Checker

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Some useful SQL queries

We will list a few useful SQL queries that can help JIRA administrators quickly find the information they are looking for. It's important to mention that new versions of JIRA are released quite regularly, with new features and bug fixes. The database schema may change slightly in new versions. Therefore, verify your SQL queries on the new version of JIRA before using them.

List of shared filters

The following SQL query will list the filters created in the JIRA instance that are shared with others:

SELECT sr.filtername, sr.authorname
FROM searchrequest sr
LEFT JOIN sharepermissions sp ON sp.entityid = sr.ID
WHERE sp.entitytype = "SearchRequest" AND sp.sharetype != "global";

Fetching users of a specific group

It's quite easy to find users of a specific group from the JIRA interface, but you should know how to fetch this information using SQL. The following query will list the users of the jira-software-users group. You can change it to any group in your instance:

SELECT...