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.

Related Content you might be interested in

Current Title:

Small book image
Mastering JIRA 7 - Second Edition
Ravi Sagar
Oct, 2016 | 450 pages
No titles found
Table of Contents (25 chapters)
Mastering JIRA 7 - Second Edition
Mastering JIRA 7 - Second Edition
Credits
Credits
About the Author
About the Author
Acknowledgements
Acknowledgements
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
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
Summary
2
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
Bulk editing
Summary
3
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
Summary
4
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
Summary
5
Understanding Zephyr and its Features
Understanding Zephyr and its Features
Installing the Zephyr plugin
Zephyr terminology
Starting to use Zephyr
Summary
6
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
Summary
7
User Management, Groups, and Project Roles
User Management, Groups, and Project Roles
User and group management
Working with project roles
Types of administrators
Summary
8
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
Summary
9
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
Summary
10
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
Summary
11
Working with Agile Boards in JIRA Software
Working with Agile Boards in JIRA Software
Product overview – JIRA Software
Scrum boards
Kanban boards
Managing multiple teams and projects using boards
Summary
12
JIRA Administration with ScriptRunner and the CLI Add-on
JIRA Administration with ScriptRunner and the CLI Add-on
Installing ScriptRunner
Installing JIRA CLI
Summary
13
Database Access
Database Access
JIRA's database schema
Accessing MySQL
Accessing PostgreSQL
User table
The jiraissue table
The customfield table
The customfieldvalue table
Some useful SQL queries
Summary
14
Customizing Look, Feel, and Behavior
Customizing Look, Feel, and Behavior
Adding your own CSS
Adding JavaScript to show/hide field
Velocity templates
Summary
15
Implementing JIRA Service Desk
Implementing JIRA Service Desk
Product overview – JIRA Service Desk?
Installing JIRA Service Desk
Summary
16
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
Summary
17
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
Final tips
Summary
18
Troubleshooting JIRA
Troubleshooting JIRA
Atlassian support
Common configuration issues
Increasing memory
Integrity Checker
Summary

The jiraissue table

The jiraissue table is used to store JIRA issues. Let's check the structure of this table.

The table structure

Run the following query:

desc jiraissue;

The output of this query is as follows:

Finding issues of a specific project

It's quite easy to find the list of issues of a specific project using the JIRA Issue Navigator, but as we are exploring the database schema and its various tables, let's fetch the issues of a specific project directly from the database:

SELECT p.id AS project_id, p.pname AS project_name, CONCAT("SSP-
",ji.issuenum)  AS issue_id, ji.reporter AS issue_reporter FROM project p 
LEFT OUTER JOIN jiraissue ji ON ji.project = p.id WHERE p.pkey = 'SSP' ORDER 
BY ji.issuenum;

The preceding query will display the list of issues of the project with the SSP key. You can replace the project key with your own and try the previous query. The project name and a few other fields are fetched from the project table.

Previous Section
End of Section 6
Next Section