Packt+ | Advance your knowledge in tech

You're reading from Mastering JIRA 7 Become an expert at using JIRA 7 through this one-stop guide!

Product type Paperback

Published in Oct 2016

Publisher Packt

ISBN-13 9781786466860

Length 450 pages

Edition 2nd Edition

Languages

Java

Tools

JIRA

Concepts

Project Management

Author (1):

Ravi Sagar

View More author details

Table of Contents (19) Chapters

Preface

1. Planning Your JIRA Installation

2. Searching in JIRA FREE CHAPTER

3. Reporting – Using Charts to Visualize the Data

4. Customizing JIRA for Test Management

5. Understanding Zephyr and its Features

6. Sample Implementation of Use Cases

7. User Management, Groups, and Project Roles

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

9. JIRA Add-On Development and Leveraging the REST API

10. Importing and Exporting Data in JIRA and Migrating Configuration

11. Working with Agile Boards in JIRA Software

12. JIRA Administration with ScriptRunner and the CLI Add-on

13. Database Access

14. Customizing Look, Feel, and Behavior

15. Implementing JIRA Service Desk

16. Integrating JIRA with Common Atlassian Applications and Other Tools

17. JIRA Best Practices

18. Troubleshooting JIRA

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: