Document toolboxDocument toolbox

SQL Reporter for Jira Home

 

Introduction

The SQL Reporter for Jira enhance your search capability in Jira. With SQL Reporter for Jira, Jira users will be able to view SQL results in data table, displaying result set into gadgets or even download or spool them into Excel files. Jira Administrator can also limit the visibility of SQL reporter based on groups.

Possible use cases

  • Generate information and statistics using SQL (JRASERVER-10455)
    • Generate statistical information for each individual projects
    • Generate user login statistics and trends with SQL
    • Generate health check report by identifying broken dependency or links
  • Generate powerful and flexible reports with SQL
    • Counting of number fields and display them in columns (JSWSERVER-9167)
    • Aggregating results and grouping by fields
    • Joining of issues from different projects