This app has been archived

You may still get support information and download previous versions of this app. Learn more.

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

Last modified 2022-11-17 • 32974 downloads • By Marketplace Expert SL

Support

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:

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

Marketplace Expert SL
http://marketplace.expert
support@marketplace.expert

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