Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in April 2023.

• added new design for pivot tables (#311)
• fixed issue with embed=1 (#361)
• added support for setFilter, setRowSpec actions (#281)
• added sourceURL generation for addon files loaded at runtime for better access using dev tools
• fixed issue with highcharts map rendering charts
• fixed click filter for world map (#183)

v3.1.83

• fixed issue with pivot table style (#311)
• changed date format for MDX requests for horolog (#338)
• fixed refresh issue for pivot table (#188)

v3.1.85

• added check for date picker filter by targetPropertyDataType equals to %DeepSee.Time.DayMonthYear

3.1.84
* fixed issue with date picker and single date selection

v3.1.86

• fixed issue with pivot table style (#311)
• changed date format for MDX requests for horolog (#338)
• fixed refresh issue for pivot table (#188)
• added "Open analyzer" context menu item for the widget (#364)
• now filter popup opens above filter field if there is not enough free space below field (#362)

KPI drillthrough

v3.2.20

dimension type

v3.2.21

more info

v3.2.22

.

v3.2.23

New SQL->JSON

Now supports JSON messages representation using json-trace package by Guillame Rongier

Support of environment variables and initial scripts is introduced.

added support for environment variables to set username, password and namespace

if set IRIS_USERNAME and user does not exists it will create, by default _SYSTEM user is used if set IRIS_PASSWORD it will set password for IRIS_USERNAME or for _SYSTEM by default if set IRIS_NAMESPACE it will create the namespace, default is USER

Support of initialization scripts is introduced.

mount folder with scripts to /docker-entrypoint-initdb.d/ expected extensions sql, sql.gz and sh

sh file may contain shebang like this, will be executed in IRIS_NAMESPACE

#!/usr/bin/env iriscli

write !,"Hello"
zpm "install dsw"

sql file, will be executed in Python Embedded mode by irissqlcli

Example

docker run -it \
 -p 9090:52773
 -e IRIS_PASSWORD=demo \
 -e IRIS_USERNAME=demo \
 -e IRIS_NAMESPACE=demo \
 intersystemsdc/iris-community:latest

Will start IRIS with already defined user demo with password demo, and created namespace DEMO

Supports Docker secrets, too

Contest badge removed

• Correctly fetch password when connecting via a Server Manager tree entry.
• Upgrade embedded Deltanji to version 7.1.

Enhancement :

• Add support of python 3.6 (RedHat 8.x)
• Deployment with PyPi

Fixes :

• file an folder named with "_"
• stronger check on Message

v2.1.1

• fix regression in message

v2.1.2

• fix support of 2023.1

v2.1.3

• bump version
• no fix, no features

Make template images tiny. Using Guillaume Rongier's approach, learn more.

Unpublish package endpoint added.

DELETE /packages/:package/:version

To turn unpublishing on add delete-enabled: true into zpm-registry.yaml (this file should be placed in the IRIS installation folder)