Skip to:

SQL+JQL Driver: Transform JQL into SQL in Jira DC

SQL+JQL Driver: Transform JQL into SQL in Jira DC

by

Marketplace Expert SL

This app has been archived. The contents of this page may by outdated. You may still get support information and download previous versions of this app. Learn more

Support

This is a supported app, so you may contact the partner (or support contact) for help:

Visit partner profile
https://kintosoft.atlassian.net/servicedesk/customer/portals

To check known issues (or if you want to file one), view this app's issue tracker.

To learn more about the app, you should:

App Description

Full control of data with maximum flexibility

All the power of SQL to take control of every detail reading issue data.

SELECT SUM, COUNT, MAX ... FROM ... JOIN ... GROUP BY ... HAVING ... OFFSET LIMIT and a lot of SQL functions for complex queries and calculations

Get the maximum value of your data from everywhere

Build end-to-end queries for Jira Core, Software & Service Desk, and other popular Marketplace apps

Build your own collection of JQL functions and custom fields

Built-in report & analytics capabilities for Dashboards

Maximum connectivity

Get the benefits of the industry-standardsPlug Jira data into your corporate ALM reporting system with web services for REST, CSV, JDBC to integrate PowerBI, Tableau etc. or export to Excel with 1-click

More details

  • Pure SQL: industry-standard, mature, popular, with well-defined data model and strong data type support
  • SQL is executed in the context of the calling user honoring Jira permissions! with no privacy leaks.
  • Support for Jira Work, Software, and Manager
  • Support for JQL to search for issues from SQL queries
  • Zero admin configuration
  • Support for standard JDBC over HTTP to connect remotely
  • Read-only
  • Support to build new JQL functions on the fly, custom fields, dashboards, etc. with support for powerful, and friendly analytics (pivot table) with drag & drop and drill down
  • Support for exporting Jira data to Excel including Pivots tables.
  • It is powered by the popular H2 Java database by reusing its SQL language parser and its high performer engine plus all the built-in H2 SQL functions to manipulate data from the queries

    • Version History

    This app has:

    Follow