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 SQLCounting of number fields and display them in columns (JSWSERVER-9167)Aggregating results and grouping by fieldsJoining of issues from different projects

Key Features

• Generate reports and statistics using SQL formulas and functions
  

• Different ways to view your reports
  View result inside a data table (Individual)Share result using gadgets (Dashboard)Download or spool result into Excel (Offline)

• Control who can access your SQL report
  

Get Started!

InstallationUser GuideAdding a new SQL report configurationHow to add SQL Reporter into your dashboardHow to upload SQL files into SQL Reporter for JiraHow to view your SQL ReportUseful SQL for JiraFinding Project Activity LevelFind all Jira issue in DatabaseFinding No. Issues for every projectFinding User Login InformationFinding Attachment LocationFinding Attachment Statistic in JiraTroubleshootingPlease inform your admin that x cannot be executedRelease NotesRelease Notes for 0.9.1Release Notes for 0.9.6Release Notes for 1.0.0Release Notes for 1.1.0Release Notes for 1.1.1Release Notes for 1.2.0Release Notes for 1.3.0