We have added new AUX.ASUSERDISPLAYNAME function

We fix a problem with calling a custom view having multiple binding params.

We have changed some links to improve navigation.

We have tuned shortcuts a little.

• We have fixed an issue when ctrl+enter refreshes navigator instead of run a query.
• Rare issue query with bindable view ("invalid planner" message) has been fixed.
• We shipped possible fix for view group sharing among users.
• OData interface should have timestamp provided instead of date.

We have fixed some issues with custom fields nullability.

We have fixed nullability in AUX.JQL and AUX. Now is null expression based on this function should work as desired.

New AUX.FORMAT function has been added. See more details here

https://codedoers.atlassian.net/wiki/spaces/SUPPORT/pages/2620915713/Function+FORMAT

Main menu is now hidden from anonymous access.

We have added new view CORE.RESOLUTIONS

We have fixed loading certain items through OData when Jira uses MS SQL Server.

We have tune performance of OData export a little bit.

We have fixed problem with exports and schema tree view when some custom views are badly defined.

We have tuned diagnostics a little bit,

We have switched on http chunks and odata streaming. Power BI should work stable now.

We have added diagnostic tools. See System settings -> Smart DB diagnostics.

⚡⚡⚡⚡⚡ ⚡⚡⚡

Small fixes here and there.

Minor fixes to CORE.CUSTOMFIELDS

Adding support for OData connectors:

• Support for Tableau
• Support for Power BI

PSQL-276 - Fixing a bug which prevents showing data in gadgets from shared views.

We have added Data transformation to Advanced Chart Gadget. See more info here.

We have added basic support to embedding Smart QL gadgets to Confluence in the same manner as other Jira gadgets.

Fixed NPE here and there.

Adding paging to SQL navigator results and table gadget as well.

Adding paging to SQL navigator results and table gadget as well.

We have added better editor with bracket autocompletion and syntax highlighting. We have added some validation of a mentioned config.

PSQL-263 - We have fixed a not working SQL navigator.

App will not freeze under Jira 8.

Compatibility with Jira 8.x was added.

We fixed a bug here and there.

PSQL-248 We fixed a bug where problems with API or license were not properly shown in gadgets.

[PSQL-247] We have added initial support for embedding gadgets in Confluence.

[PSQL-243] We have patched isse where users without UI access permission should have still access to Smart QL gadgets.

[PSQL-245] - We make same fixes towards possible bug in CORE.CUSTOMFIELDS

Improvements

[PSQL-229] Chart gadget icon was changed to more meaningful

Bugs

[PSQL-234] Squashed bug when date is null and it shows as "invalid date" instead of being empty

[PSQL-236] Tree panel in navigator was tuned visually for Jira 7.13

[PSQL-238] - Squashed a bug when CORE.FILTERS limits rows to 100

[PSQL-239] Resources for chart gadget was optimized

[PSQL-241] Squshed a bug when table gadgets won't work in JIRA 7.2/7.3

New Feature

• [PSQL-211] - New AUX.ASTEXT function
• [PSQL-224] - Chart gadget

Bug

• [PSQL-213] - Gadget shows no error messages
• [PSQL-220] - Possible bug when example or shared too long
• [PSQL-228] - Incorrect column names in web api

Improvement

• [PSQL-218] - Log execution times for queries.

Bug

• [PSQL-223] - CORE.ISSUELINKS/FIXVERSIONS/AFFECTEDVERSION are empty when with MYSQL/MSSQL

Epics

[PSQL-171] Shareable views - share custom views/queries to coworkers.

[PSQL-172] Queries with bindable params - you can now use "?" params.

[PSQL-181] Adding editor for common parameter types

[PSQL-191] Use parametric views as table functions, like "SELECT * FROM TABLE(AUX.TIMESHEET('admin', TIMESTAMP '2018-12...', ...))"

[PSQL-195] New example Timesheet showing how to use bindable params.

Features

[PSQL-192] Views with dynamic parameters can be selected in gadget.

[PSQL-214] Making SQL editor re-sizable

Improvements

[PSQL-53] Caching connection for speed.

[PSQL-212] Showing functions input parameter types in navigator.

Bugs

[PSQL-193] - Download CSV don't work with parametric queries

[PSQL-206] - Date/Time dynamic params not pushed correctly to jdbc prepared statement in H2

[PSQL-215] - Make gadgets and navigator prune to very long queries

[PSQL-217] - For some queries pushing bindable params cause native db errors

[PSQL-207] - When raw Jira DB is numeric like (not bigint) AUX functions with Long parameters are not matched.

We fix some things here and there, especially:

• [PSQL-202] - Same column name in projection from different tables glitch.
• [PSQL-209] - When Jira raw database is mssql server incorrect cast varchar is created

Improvement

• [PSQL-204] - Smart Ql navigator UI loading indicator. Now you will see if navigator is still launching.

Bug

• [PSQL-189] - Bug fixed "Join AUX.JQL with other tables may result with java.lang.IndexOutOfBoundsException: Index: 1, Size: 1."
• [PSQL-203] - Bug fixed "User without "Use SmartQL from UI" permission can browse views tree"
• [PSQL-205] - Bug fixed "Empty options when add Smart QL Table Result gadget

Improvement

• [PSQL-190] - Renaming KICKOFF and DUE from CORE.PROJECTVERSIONS to STARTDATE and RELEASEDATE

Bug

• [PSQL-187] - PreparedStatement.setParameter does not work

New Feature

• [PSQL-116] - New view CORE.STEPS
• [PSQL-188] - New column ISSUETYPEOBJECT in JQL and GETFIELD functions

Some bugs squashed here and there. Build process updated.

We have fix an issue which prevents export some tables when Jira uses MS SQL Server

New Features

Only one feature but really great :)

• [PSQL-155] - Introduce API for using Smart QL from other add-ons

Improvements

Our app will speedup now during JIRA startups. With following changes we can deliver new versions faster. But we drop support for JIRA 7.0 and 7.1.

• [PSQL-174] - Support for Jira 7.12.x
• [PSQL-176] - Moving to Atlassian Spring Scanner

Bugs

• [PSQL-178] - Possibility to override web resources between addons

Improvement

• [PSQL-162] - Support for DateTime custom field in AUX.JQL and AUX.GetField
• [PSQL-164] - More informative param names in AUX functions
• [PSQL-167] - Prune and tune dependencies - smaller obr file

New Feature

• [PSQL-156] - Ability to use XPath in projections in AUX.JQL and AUX.GETFIELD
• [PSQL-168] - New fields in AUX.JQL and AUX.GETFIELD: ASSIGNEOBJECT, CREATOROBJECT, PROJECTOBJECT, REPORTEROBJECT, AFFECTEDVERSIONS, FIXVERSIONS, COMPONENTS, VOTES, WATCHES, SUBTASKS, ATTACHMENTS, LABELS
• [PSQL-169] - New function AUX.PATH

Improvement

• [PSQL-166] - New table gadget logo and marketing screenshot

Bug

• [PSQL-159] - Lateral joins not work when saved as custom views
• [PSQL-160] - Convert null to long error in MYPLANNEDTOTALWORK example
• [PSQL-165] - NPE in AUX.ASICON and AUX.ASLINK

New Feature

• [PSQL-140] - Table gadget
• [PSQL-151] - Browser tree in navigator

Task

• [PSQL-163] - New marketing materials

Bugs:

• [PSQL-148] - Invalid projection validation in AUX.JQL function
• [PSQL-158] - EXAMPLES schema is not browsable through JDBC

Features:

• [PSQL-157] - Support for JIRA Datacenter

[PSQL-150] - When creating connection pool from scratch - no driver loading is being done. This bug leads to blank screens.

[PSQL-152] - Failing export due to missing url encode. This bug leads to unable to export some JQL queries to Smart QL queries.

[PSQL-149] - Broken support for JIRA 7.0.0

[PSQL-150] - When creating connection pool from scratch - no driver loading is being done

Features

[PSQL-121] - Global permissions for using Smart QL

• [PSQL-145] - Global permission for using UI in JIRA
• [PSQL-146] - Global permission for using JDBC

Bugs

[PSQL-144] - Aggregate functions on timestamp produce NPE *

[PSQL-137] - When saving view: order by clause not validated properly when columns are from AUX.JQL function table

[PSQL-138] - NPE when AUX.JQL used in one column projection with null values at some rows

Features

[PSQL-114] - Initial support for JIRA Software

• [PSQL-130] - New view SOFTWARE.SPRINTS
• [PSQL-129] - New view SOFTWARE.BOARDS
• [PSQL-132] - New view SOFTWARE.COLUMNS
• [PSQL-133] - New view SOFTWARE.COLUMNSTATUSES

[PSQL-123] - New table CORE.FILTERS

Improvements

[PSQL-126] - Change dialect for support identifiers with multiple words

Bugs

[PSQL-119] - Schemas other than CORE not visible via JDBC driver[PSQL-122] - JdbcMeta has hardcoded schemas[PSQL-124] - NPE in AUX.GETFIELD and AUX.JQL[PSQL-125] - Renaming CORE.FIXEDVERSIONS to CORE.FIXVERSIONS[PSQL-127] - CROSS JOIN LATERAL TABLE(JQL()) not working

Improvement

• [PSQL-105] - Ability to create new view from custom view list

Bug

• [PSQL-80] - Tests must have exact order

New Feature

• [PSQL-112] - New view CORE.FILEATTACHMENTS
• [PSQL-115] - New view CORE.CUSTOMFIELDS and new function AUX.FIELD()

New Features

• [PSQL-95] - Ability to convert/export JQL or basic issue search to SQL
• [PSQL-108] - New function AUX.LOGGEDINUSER
• [PSQL-109] - New function AUX.ASDURATION
• [PSQL-110] - New function AUX.ASPROJECTNAME * [PSQL-111] - New function AUX.ASPROJECTKEY
• [PSQL-97] - Collection of builtin queries, reports and views
• [PSQL-98] - Ability to manage own custom queries
• [PSQL-99] - Additional schema with user custom queries as views
• [PSQL-100] - Additional schema with builtin example queries
• [PSQL-101] - A few builtin views/queries as example schema**

Bugs fixed

• [PSQL-96] - Inconsistent columns for JQL function between user type fields

* [PSQL-93] - New view STATUSES in CORE

* [PSQL-94] - Internal engine updates

** Improvement *

[PSQL-90] - Change welcome SQL in navigator

** New Feature *

[PSQL-91] - Add ASISSUEKEY function

• [PSQL-64] - Change JIRA name schema to CORE

• [PSQL-85] - New function - ASLINK
• [PSQL-89] - New function - ASICON

Improvement

• [PSQL-61] - More expressive errors from JQL functions

Bug

• [PSQL-43] - Clean comments from merged pull request
• [PSQL-71] - Incorrect dependencies in volatile third party bitbucket repository - see calcite
• [PSQL-72] - Bad request when retrieving tables metadata
• [PSQL-73] - Pool leak and incorrect created jdbcschema
• [PSQL-74] - Incompatible calcite bigint with numeric(18,0) postgres
• [PSQL-76] - CAST(? AD BIGINT) does not work in MySQL

New Feature

• [PSQL-18] - New view Priorities
• [PSQL-63] - Enable custom fields in JQL(...) function

Task

• [PSQL-65] - Tests against postress
• [PSQL-66] - Tests against mysql/mariadb
• [PSQL-67] - Tests against oracle db
• [PSQL-68] - Tests against sqlserver
• [PSQL-69] - Extended error/exception logging
• [PSQL-70] - update maven wagon to 0.5.0

Maintenance version. Code cleaning, bugs squashing here and there.