Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

9.12.0

  • Some functions and columns return now the original string value (without any transformation). Please use some of these auxiliary functions to see the content safely and properly from the browser and to avoid potential XSS attacks:
    • escape(): escapes raw text to be displayed safely from a browser.
    • htmltext(): extracts texts from HTML content.
    • wikiHtml(): transforms wiki markup into HTML.

The affected functions are:

  • description(JQL.ISSUE): extracts the issue description.
  • environment(JQL.ISSUE): extracts the environment string from the issue.

The affected columns are:

  • ISSUECOMMENTS.BODY

To figure out the affected saved queries you may want to use the this query: 

SELECT * FROM AUX.SAVEDQUERIES

9.11.1 

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

9.11.0

...

  • 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.

7.11.0

  • IMPROV: New ISSUESAVEDFILTER and SAVEDFILTERS tables. Read more.

...

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

7.6.5

  • Fix: ESTIMATED function not found

7.6.4

  • 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)

7.4.0

  • 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.

...