9.11.1

...

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:

...

FIX: SQL+JQLreturned the user's key (like JIRAUSER000001) instead of the username (the expected value) for some few (but critical) columns. This made difficult to join tables and understand the results due to this incoherence mainly to make queries based on users' activity. This issue affected all these columns:
- ISSUES.REPORTER
- ISSUEWORKLOGS.AUTHOR
- ISSUEWORKLOGS.UPDATEDBY
- ISSUEATTACHEMTS.AUTHOR
- ISSUEVOTERS.USERNAME
- ISSUEWATCHERS.USERANAME
- ISSUECHANGES.USERNAME
- ISSUECHANGES.FROMVALUE and ISSUECHANGES.TOVALUE (they might require using the usernameKey() function if a user's key is returned).
- ISSUESTATUSTRANSITIONS.PERFORMER
- reporter(JQL.ISSUE) function (see 7.11.1 version)
FIX: The ISSUECHANGES.USERNAME always returned the issue reporter instead of the change performer.
IMPROV: a new usernameKey() function is provided to help to transform any user key into its corresponding username wherever the app is unable to know whether the data contains a username.

7.11.1

FIX: The reporter() function extracts an internal user key instead of the username from the JQL.ISSUE column.

...

Support for Jira 8
Fix: improved error management when the console is opened without enough parameters

Fix: unexpected null pointer exception breaks the normal termination of the plugin causing unrecoverable state

...

New functions to extract data from the Issue Java Objects on the JQL table to avoid joining common tables like ISSUECUSTOMFIELDVALUES, ISSUESTATUS, ISSUEPRIORITIES. Performance can be increased a lot ( > 5 times faster)

IMPROV: New columns on the ISSUEWORKLOGS table. Now it is possible to search for the updated work logs from a date.
IMPROV: New ABSOLUTEURL to conver Jira relative paths into absolute URLs
IMPROV: Most of the built-in examples have been re-written to use the JQL instead of the ISSUES table to improve performance
FIX: Bug introduced in the previous 7.2.0 version: the table ISSUES returns no data when any index is used instead of raising an exception.

...