We have added new AUX.ASUSERDISPLAYNAME function
Version history
6.15.0Jira Server 7.2.0 - 8.21.12022-01-28New AUX.ASUSERDISPLAYNAME function 6.14.0Jira Server 7.2.0 - 8.21.12021-12-27Fixes in OData No release notes.6.13.1Jira Server 7.2.0 - 8.21.12021-12-23JDK 11 & OData fixes No release notes.6.13.0Jira Server 7.2.0 - 8.21.12021-07-17Calling custom view with param littel fixes We fix a problem with calling a custom view having multiple binding params.
6.12.0Jira Server 7.2.0 - 8.17.12021-06-24Nabigation improvements We have changed some links to improve navigation.
We have tuned shortcuts a little.
6.11.0Jira Server 7.2.0 - 8.17.12021-06-22Fixes and improvements - 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.
6.10.1Jira Server 7.2.0 - 8.17.02021-06-01Fixing nullability of custom fields We have fixed some issues with custom fields nullability.
6.10.0Jira Server 7.2.0 - 8.17.02021-05-31Fixining SQL nullability in AUX functions We have fixed nullability in AUX.JQL and AUX. Now is null expression based on this function should work as desired.
6.9.0Jira Server 7.2.0 - 8.17.02021-05-20New AUX.FORMAT function 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.
6.8.0Jira Server 7.2.0 - 8.15.12020-12-07New view CORE.RESOLUTIONS We have added new view CORE.RESOLUTIONS
6.7.0Jira Server 7.2.0 - 8.14.12020-12-02OData fixes No release notes.6.6.0Jira Server 7.2.0 - 8.14.12020-11-30OData fixes 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.
6.5.0Jira Server 7.2.0 - 8.14.12020-11-25Increasing number of diagnostic test We have tuned diagnostics a little bit,
6.4.0Jira Server 7.2.0 - 8.13.62020-11-03Odata performance tuning We have switched on http chunks and odata streaming. Power BI should work stable now.
6.3.0Jira Server 7.2.0 - 8.13.62020-11-02Diagnostics improvements and mysql fixes No release notes.6.2.0Jira Server 7.2.0 - 8.13.62020-10-29New diagnostic tool We have added diagnostic tools. See System settings -> Smart DB diagnostics.
⚡⚡⚡⚡⚡ ⚡⚡⚡
6.1.0Jira Server 7.2.0 - 8.12.32020-09-07Fixes Small fixes here and there.
6.0.1Jira Server 7.2.0 - 8.12.32020-09-04Fixes Minor fixes to CORE.CUSTOMFIELDS
6.0.0Jira Server 7.2.0 - 8.12.32020-08-31OData support Adding support for OData connectors:
5.7.0Jira Server 7.2.0 - 8.12.32020-07-20Fixes PSQL-276 - Fixing a bug which prevents showing data in gadgets from shared views.
5.6.0Jira Server 7.2.0 - 8.10.12020-07-09Experimental support for Confluence and data transformation in charts 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.
5.5.2Jira Server 7.2.0 - 8.9.12020-05-19Bugfixing Fixed NPE here and there.
5.5.1Jira Server 7.2.0 - 8.8.12019-11-14Making tables pageable Adding paging to SQL navigator results and table gadget as well.
5.5.0Jira Server 7.2.0 - 8.5.142019-11-14Making tables pageable Adding paging to SQL navigator results and table gadget as well.
5.4.0Jira Server 7.2.0 - 8.5.142019-11-05Improvements in JSON configuration editor in advenced chart gadget We have added better editor with bracket autocompletion and syntax highlighting. We have added some validation of a mentioned config.
5.3.2Jira Server 7.2.0 - 8.5.142019-10-22Hot fixes No release notes.5.3.1Jira Server 7.2.0 - 8.5.142019-10-17Fixing SQL navigator window PSQL-263 - We have fixed a not working SQL navigator.
5.3.0Jira Server 7.2.0 - 8.5.142019-10-14Adding experimental charting gadget with advanced configuration No release notes.5.2.2Jira Server 7.2.0 - 8.5.142019-10-09Fixing queries of custom fields with date type No release notes.5.2.1Jira Server 7.2.0 - 8.2.62019-07-10Hotfix App will not freeze under Jira 8.
5.2.0Jira Server 7.2.0 - 8.2.62019-07-03Compatibility with Jira 8.x Compatibility with Jira 8.x was added.
5.1.4Jira Server 7.2.0 - 7.13.182019-06-06Oracle compatibility fixes No release notes.5.1.3Jira Server 7.2.0 - 7.13.182019-02-28Bug squashing We fixed a bug here and there.
5.1.2Jira Server 7.2.0 - 7.13.182019-02-28Bugs squashing PSQL-248 We fixed a bug where problems with API or license were not properly shown in gadgets.
5.1.1Jira Server 7.2.0 - 7.13.182019-02-25Bugs squashing [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
5.1.0Jira Server 7.2.0 - 7.13.182019-02-12Little improvements and bugs squashing 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
5.0.0Jira Server 7.2.0 - 7.13.182019-01-08Adding chart gadget and some fixes New Feature
Bug
4.0.1Jira Server 7.2.0 - 7.13.182018-12-13Fixes 4.0.0Jira Server 7.2.0 - 7.13.182018-12-12Shareable views, bindable parameters and UI tuning 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
3.4.3Jira Server 7.2.0 - 7.13.182018-12-03Fixes [PSQL-207] - When raw Jira DB is numeric like (not bigint) AUX functions with Long parameters are not matched.
3.4.2Jira Server 7.2.0 - 7.12.32018-11-29Fixes We fix some things here and there, especially:
3.4.1Jira Server 7.2.0 - 7.12.32018-11-22Hotfixes Improvement
- [PSQL-204] - Smart Ql navigator UI loading indicator. Now you will see if navigator is still launching.
Bug
3.4.0Jira Server 7.2.0 - 7.12.32018-10-11Improvements Improvement
- [PSQL-190] - Renaming KICKOFF and DUE from CORE.PROJECTVERSIONS to STARTDATE and RELEASEDATE
3.3.0Jira Server 7.2.0 - 7.12.32018-10-09New STEPS view and bug fixes 3.2.0Jira Server 7.2.0 - 7.12.32018-09-23Maintenance Some bugs squashed here and there. Build process updated.
6.6.1Jira Server 7.2.0 - 8.14.12020-12-02OData fixes We have fix an issue which prevents export some tables when Jira uses MS SQL Server
3.0.0Jira Server 7.2.0 - 7.12.32018-09-13Enabling API and integrating with Smart Reports 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.
Bugs
- [PSQL-178] - Possibility to override web resources between addons
2.4.0Jira Server 7.0.0 - 7.12.32018-08-23Support for XPATH, more fields in AUX.JQL & AUX.GETFIELD, new AUX.PATH 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
2.3.0Jira Server 7.0.0 - 7.11.22018-08-17Dashboard gadget, schema navigator and fixes 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
Task
- [PSQL-163] - New marketing materials
2.2.0Jira Server 7.0.0 - 7.11.22018-08-03Support for Data Center and bugfixing 2.1.2Jira Server 7.0.0 - 7.11.22018-07-31Bugfixing 2.1.1Jira Server 7.0.0 - 7.11.22018-07-26Fixing compatibility with JIRA 7.1x and 7.2.x and other fixes 2.1.0Jira Server 7.2.0 - 7.11.22018-07-23New features like global permissions, bugs squashed 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 *
2.0.1Jira Server 7.0.0 - 7.11.22018-07-12Bug fixes 2.0.0Jira Server 7.0.0 - 7.11.22018-07-11Support for JIRA Software, and other dynamic schemas 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
1.1.0Jira Server 7.0.0 - 7.10.22018-06-11Support for custom fields 1.0.0Jira Server 7.0.0 - 7.9.22018-05-23Saving queries as views, built-in example views & new helper functions 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
0.5.0Jira Server 7.0.0 - 7.9.22018-05-02Features * [PSQL-93] - New view STATUSES in CORE
* [PSQL-94] - Internal engine updates
0.4.0Jira Server 7.0.0 - 7.9.22018-04-25New features ** Improvement *
[PSQL-90] - Change welcome SQL in navigator
** New Feature *
[PSQL-91] - Add ASISSUEKEY function
0.3.0Jira Server 7.0.0 - 7.9.22018-04-16Features - [PSQL-64] - Change JIRA name schema to CORE
0.1.0Jira Server 7.0.0 - 7.9.22018-04-05Bug fixes 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
Task
3.1.0Jira Server 7.2.0 - 7.12.32018-09-22Maintenance Maintenance version. Code cleaning, bugs squashing here and there.