10.0.5

• Fix: Custom fields configuration cannot be saved in Jira 9

Despite this fix, you may get an XSRF warning. Read more

10.0.4

• Fix problem accessing to Jira data via remote JDBC Driver

10.0.3 (Security fix)

• XSS vulnerability fixed

10.0.2 (Security fix)

• XSS vulnerability fixed

10.0.1 (Security fix)

• XSS vulnerability fixed

10.0.0 (Jira 9 support)

• Support for Jira 9

• Third-party drivers support discontinued: No longer support neither for Subversion ALM, Zephyr, nor Git . Therefore the app no longer reuses the Subversion ALM license (if any). If the app is used for Jira reporting then a new commercial license for SQL+JQL is required. If you use it for Subversion ALM reporting then please downgrade to the latest compatible versions (SQL+JQL Driver 9.11.3 and Subversion ALM 9.3.4)

• Support for data drill-down from Pivot table charts. Now it is possible to click on chart parts (bars. dots, etc) to view the issues.

• Other minor bug fixes.

9.11.3 (Critical Security fix)

• It fixes a critical vulnerability in Jira affecting many apps. Please read CVE-2022-0540 for more information

9.11.1 

• Fix: dialogs from the Examples are empty (bug introduced in the 9.10.8 version.

9.11.0

• New table ISSUESTATUSASSIGNEES. It allows reporting the Time in Status by assignee in a straightforward way. An example is also available from the console.

Open

9.10.10

• A progress bar is displayed while the query is being executed:

Open

9.10.9

• Fix: SVN API. The new column MAXITEMS on the SVN.ITEMWITHISSUES table required a value otherwise a NullPointerException was raised. Now, this column is optional for backward compatibility. (Bug introduced in the 9.10.0 version)

9.10.8 (Security fix)

• FIX: A malicious Jira project admin can inject code (XSS)

• FIX: Input dialogs from Examples do not display special characters properly.

9.10.7 (Security fix)

• FIX: A malicious Jira user (not trusted) can inject code (XSS) 

9.10.6

• Residual cache files clean up when the app is updated or re-enabled to save space.

• The error message when the console session becomes expired has been improved helping users to solve it and reducing the requests for support to administrators:

Open

9.10.3

• Support for changing the location of the cache. The default value is the Jira's temp directory. If it grows in ecess then the JIra performance can be affected, so you may want to move it another less critical directory.

Open

9.10.2

• FIX: Jira Local URL not updated properly.

9.10.1

• Improv: issue in sql(...) performs twice faster.

9.10.0

• Improv: Performance of the API with Subversion ALM has been improved a  little. Subversion ALM has to be upgraded to 9.1.0 or above. Otherwise, the queries will not work:

Open

9.9.1

• Fix: save queries with parameters did not work

Open

9.9.0

• New tables to support all the schemes. The previous SCHEMES and SCHEMEPROJECTS tables have also been dropped and replaced by their respective ones. Each scheme has now its own SCHEMEXXXS and SCHEMEXXXPROJECTS tables.

Open

9.8.0

• A new SOFTWARE.EPICISSUES table is supported.

Open

9.7.2 (Security fix)

• Some user URLs have been protected against potential CSR that could lead to XSS attacks.

9.7.1 

• FIX: JDBC driver errors were not properly reported. This requires upgrading 2.0.1 version of the JDBC Java binary library (jar) available for download from JDBC.

9.7.0 (Security fix)

• SECURITY: A critical vulnerability has been fixed on Windows servers. Please upgrade ASAP. Read more from the Security bulletin

• IMPROV: The performance of data serialization over the network has been improved (up to x10 faster) when using JDBC for remote access. The Java library (jar) has to be upgraded from the client applications. Please download the new version from JDBC

• FIX: Some foreign constraints have been fixed.

9.6.4

• FIX: Not possible to save queries with parameters (bug introduced in version 6.5.1) displaying the following error message:

Open

9.6.3

• FIX: The owner or the updater of a work log is not informed by the Atlassian's API causing NullPointerException.

9.6.2

• IMPROV: New PROJECTROLEDEDINITIONS table. PROJECTROLES re-engineered and PROJECTROLACTORUSERS dropped from PUBLIC schema. See the new Project Roles subschema.

• FIX: ISSUEWORKLOGS casting error from DATE to TIMESTAMP type on the UPDATEDFROM column

• FIX: Wrong indexed columns displayed on FULLSCAN error messages when a table that supports full scans (i.e PROJECTS) is present early in the query.

9.6.1

• FIX: target param ignored in the link(issue, target) function, so the issue is always opened in the _self target.

• IMPROV: new contextPath() function

• FIX: Blank JQL in the Issue Navigator are exported into the console as  a "null" instead of a blank string.

• New example to learn how to write interactive user interfaces with AUI, Javascript, and the Jira REST API. In addition, a new video showing the power of this feature (already present in previous versions) has been recorded:

9.6.0

• IMPROV: The Action to open the SQL+JQL console has been moved in the Issue Navigator from the Export menu to the main Action menu at the top of the page. It fixes some problems reported with the previous menu and redirection to the console. In addition, the button is only displayed when the user is granted to open the console. 

Open

• FIX: The errors displayed on the console are not properly formated (new lines missing). This is a bug introduced in the previous version.

9.5.1 (Security fixes)

• We have contracted the services of some ethical hackers from Russia and they have reported some vulnerabilities that have been fixed in this version. Read more...

• Support for displaying indexed columns from the Tables view on the SQL+JQL Console:

Open

9.5.0

• IMPROV: New AUX.SPLIT table to transform strings into rows.

9.4.1 (Security Fix)

• FIX: It was possible for a Jira user to perform an XSS attack from one URL. Credits for Ivan Rumak and Alexey Rumak that reported it via https://detectify.com/. Thank you!

   

9.4.0

• FIX: Support for Jira 8,10. The FROMVALUE and TOVALUE columns on the ISSUECHANGES table have been anonymized on Jira: the API returns the user key instead of the username for:

  • assignee: (FIXED) it returns the username for backward compatibility

  • reporter: (FIXED) it returns the username for backward compatibility

  • Single- and Multi-user picker custom fields: (NOT FIXED) you have to modify your query to use the usernameKey() function to get the username from the user key for both columns. 

9.3.3

• IMPROV: A more relaxed security policy (without compromising data privacy, of course) on the ADMIN.GROUPUSERS table to cover more real use cases.

9.3.2

• Fixed bugs introduced in the 9.3.0 version as some services stopped to work because a missing javax class causing

  • Jira 8.x:

    • Cannot connect from remote JDBC

  • Jira 7.x:

    • Cannot connect from Remote JDBC

    • Cannot export data via web services to JSON and CSV format

    • Some views (Pivot table) do not work as it uses the export web services

9.3.1

• FIX: Some characters in the JQL (leas and great than,.. < >) break the SQL+JQL console GUI when exported from the Issue Navigator

Open

• FIX: Parameters in the URL are ignored by shareable tables

Open

9.3.0

• NEW SVN schema to report Subversions commits. It works when the Subversion ALM app is installed.

Open

9.2.5

• FIX: ISSUECOMPONENTS table returns one component maximum per issue. Now, it returns all the components.

9.2.4

• FIX: Some Time custom fields did not work

• IMPROV: Darker gray color in Pivot Table headers to increase contrast with white labels

Open

9.2.3

• FIX: Support for exporting filters on Pivot Rows and Columns to Excel

9.2.2

• FIX: Some charts on gadgets do not match the height on Pivot Tables

9.2.1

• Regression FIX: The height of the pivot gadget is not preserved. Bug introduced in previous 9.2.0 version

9.2.0

• Support exporting Pivot Tables to native Excel files. It saves time to export and build a basic Pivot table. It works on all browsers.

  • Limitations: 

    • Charts are ignored

    • Other aggregators than Count are ignored

Open

• In gadgets there is a new option to show/hide the Export to Excel icon:

Open

• FIX: Pivot table header colors has been changed from blue to light gray to avoid conflicts with hyperlink colors.

9.1.4

• IMPROV: The Pivot Table looks & feels more Jira alike

Open

• FIX: Missing graphics libraries in the Pivot Table gadget

9.1.3

• IMPROV: Issue serialization has come back. It was disabled in previous versions due to major errors with the Oracle's Driver and other database vendors. It's recommended to upgrade to this version to avoid potential memory excessive consumption issues. 

9.1.2

• FIX: Wrong message when the Local URL is changed and the app re-enabled. The message was not updated accordingly looking like the saved changes were ignored.

9.1.1

• FIX: Edit custom fields error message

Open

9.1.0

All the USER-related tables re-engineered.

Some tables have been renamed (PUBLIC,GROUPS → PUBLIC.USERGROUPS  and ADMIN.USERGROUPS → ADMIN.GROUPUSERS) and some new tables created.

See this page for the complete list:  Users

Now it is possible to check the current user's permissions (global, project and issue levels) and check if the current user belongs to a specific group.

This allows trusted users to write queries and drop records if the current user does not meet certain security constraints.

9.0.2

• A number of minor bug fixes and enhancements.

9.0.1

• A number of regression and another type of bugs fixed.

9.0.0 (Major Version)

• Support for Zephyr for Jira: report your cycles, executions, tests, cycles, defects, etc, and relate them with Jira Core, Software and Service Desk data and Subversion and Git commits to make powerful and comprehensive end-to-end reports. Read more: Zephyr

Open

• FIX: Massive failure with TIMESTAMP columns on Oracle which made the app almost unusable with that database vendor.

8.0.8

• FIX ISSUECHANGES searching for username (author) did not work.

• CHANGE: ISSUECHANGES.INTERVALTIME column dropped.

8.0.7

• FIX: Improved HTML support in Pivot Table charts

Open

8.0.6

• FIX: URL column on USERAVATARS table did not show the correct URL value.

• FIX: Progress Bar example did not use the exported JQL 

• IMPROV: Support for HTML in PIvot Table cells (Demo)

Open

8.0.5

• Minor improvements: two new functions are supported to extract data from the JQL.ISSUE object:

  • progressbar(jql.issue)

  • projectkey(jql.issue)

8.0.4

• FIX: The SQL function returns older values when used as a filter from boards (it might also happen from other locations)

• IMPROV: New progressbar function. A new example has also be included.

Open

8.0.3

• FIX: Error message when Subversion ALM is installed.

Open

• IMPROV: License management has been improved when Subversion ALM is installed to give clearer messages about the situation to our customers.

8.0.2 

• Initial commercial version.

• Improved internal API management by reducing the number of injected objects a lot.

• New ​BBBGit schema to integrate the BigBrandBass's Git integration for Jira app​.

• More third-party app integrations are coming...

• IMPORTANT: Since it is no possible to release free versions for commercial apps on the Atlassian Marketplace anymore, the new free versions must be downloaded from our servers (hosted on Google Drive) and installed on Jira manually:

7.21.1 (Security Fix)

7.21.0 (Security Fix)

7.18.4 (Security Fix)

7.18.3

7.18.2

7.18.1

7.18.0

7.17.10

7.17.9

7.17.8 

7.17.7 

• A cumulative release of bug fixes and small improvements taken from the commercial version.

7.17.6

• FIX: The SQL function returns older values when used as a filter from boars (it might also happen from other locations)

7.17.5

• Improved internal API management by reducing the number of injected objects a lot. 

7.17.4

• Improved error messages management. Now, when a saved query fails its name and description are shown along with the error message. This allows trusted users to provide helpful information about how to use the saved query. This applies to error displayed by the sql function, gadgets, and shareable URLs. Example:

Open

7.17.3

• Support for input paremters from URLs, The users can append paramters to the URL. They are optional and must start by param1 conseutively: param1=...&param2=-...&param3=...

Open

• and from gadtes too (same paramter format: param1=...&param2=-...&param3=...

Open

7.17.2

• Support to export to CSV file format in 7.17.0 version (it had been replaced by REST+JSON) is come back as per users' request. IMPORTANT: The URL has changed and now it also requires a saved query Id, therefore any previous query must be saved first and then get the CSV URL later as shown in the picture below.

Open

7.17.1

• Fix: regression bug introduced in the previous 7.17.0 version. Console actions did not work. Save → missing button and  PIvot table → shows runtime error

Open

• Fix: Console actions not displayed in Internet Explorer 11

• Fix: Users view only their own saved queries from the gadgets. → Now they can see all the saved queries sorted by their ID desc.

Open

• IMPROV: Some security checks added to the server to avoid malicious users to modify the page source to perform unauthorized actions.

7.17.0 (Major bugs → please upgrade to 7.17.1)

NOTE: The goal of this version is to avoid non-trusted users from writing their custom queries. The expected behavior is that only a set of trusted users write queries for the rest of the organization. This is the list of modifications that we have made to achieve it:

• The infamous message "It has occurred and error on an UNKNOWN table... we have to improve this..." has been resolved and now all the tables are properly identified when a required index column set is not provided.

• New AUX.SAVEDQUERIES table. It allows any user to search for saved queries. Saved queries is a sort of corporate catalog of queries that the rest of the users can run from gadgets and use them as external data sources.

•  Breaking change: The sql function to transform SQL+JQL queries into JQL no longer accepts a plain text query as input param. Only a saved query id as supported. In addition, parameters are now supported. In the example below a saved query with #ID = 527 with one parameter is invoked from the Jira Search view. In this way, it is possible to build a catalog of pure JQL functions identified by their saved query IDs and accepting parameters. It is for that reason that we have created the AUX.SAVEDQUERIES table above to allow the users figuring out the meaning of the IDs.

Open

NOTE: in order to reuse your saved filters in Jira, you must save the queries first and use their ID instead.

• Breaking change: CSV data sources have been dropped as they allowed non-trusted users to run their own queries. Now, a saved query ID must be used as an input parameter of a REST service that returns the records in the JSON format. A new link to get the REST URL and copy it into the clipboard is now provided.

Example of URL executing the query with  #ID = 430 and getting the output in JSON format.

Open

NOTE: in order to reuse your query data sources, you must save the queries first and use the new REST URL entry point.

7.16.2

• IMPROV: new features added to the internal API for better integration of BigBrassBand's Git integration for Jira app

7.16.1

• FIX: Error in the configuration page

Open

7.16.0 

• NEW: Custom Fields are now managed from this app. This app (SQL+JQL Custom Fields) is discontinued and its functionality replaced by this. Both apps are incompatible now and all the SQL+JQL custom fields must be migrated.

7.15.2

• IMPROV: Support for AUI 8.5.1. The app look&feel is a bit modern now and the status lozenge colors according to the newer Jira versions across all the views.

Open

7.15.1

• It provides a new feature to Audit users' activity and performance statistics

Open

• FIX: It fixes a critical bug introduced in the previous version that lefts opened the connections to manage the internal cache until it becomes unusable. 

• IMPROV: The cache's database pool (that is different than the app's database connecion pool) is now displayed on the configuration page to anticipate bugs like the one intoduced in the previosu versions if the connections are not properly closed (this information is mainly useful for our developers only as you do not have control over it).

Open

7.15.0 (Critical bug. Please Upgrade to fix it)

• This release puts the foucs on performance ensuring that each mehtod of the Atlassian's Jira public Java API is invoked once and only once (with the same parameters) per connection among other performance improvements:

  • FIX Internal cache was not properly cleaned up. It grew unlimmited and might degrade performance .

  • NEW built-in cache for REST-based services

  • IMPROV: IsseuService API is no longer used. All the issues are now fetched via the SearchService instead (Jira native database vs JIra Lucene Index)

• FIX: The ISSUES table raises a NullPointerException if the reporter is null.

7.14.12

• FIX:It fixes the Deserialization error reported by some organizations

Open

7.14.11

• FIX: Wrong FROM column value in the built-in Transtions example.

7.14.10

• FIX: The internal API does not drop the dynamic schema plugged by third-party apps (like Subversion ALM) when the contributor is disabled → The tables remain and they throw an exception when invoked. (Bug introduced in the 7.14.0 version).

Open

• IMPROV: New method added to the internal API for coming soon third-party integrations (i.e: BBB Git, Zephyr...) and user's context-based REST services.

• IMPROV: Support for Jira Local URL is back. It will help to resolve some configuration issues related to third-party integrations invoking REST services.

Open

7.14.7

• FIX: Sometimes upgrading the app fails and it needs to be reinstalled. Now, it looks like definitively fixed and the app should work just after every upgrade.

• FIX: Removed the action to reset the connection pool as it did not work as expected. Now, the plugin must be re-enabled to reset the SQL+JQL database connection pool.

Open

• IMPROV: the cache status is reported in the app's configuration page. In previous versions was not possible to know whether the internal cached was working nor the error.

Open

7.14.5

• Fix: 7.14.4 also supported from the pivot table when displayed on the console.

• IMPROV: Actions available for the table to export, save, pivot, etc. properly managed. 

7.14.4

• FIX: Support for HTML in the Pivot Table Gadget: Now it is possible to display images, lozenges, links, etc.

Open

7.14.3