Docs

7.3.2

• Fixes bug that prevents data source tables from being exported.

7.3.1

• Increases the Spring Boot max threads to 400.
• Optimizes concurrency when refreshing materialized data queries.

7.3.0

• Adds StableNet Data source type which uses the StableNet Foreign Data Wrapper.
• Fixes bug that causes mismatch between Engine values and value definitions.
• Fixes a bug that causes very bad database performance on big datasets when filtering for integer values.
• Various other performance optimizations for big datasets.
• New export / import endpoints for dashboards and data queries.

7.2.15

• Fixes Data Source data import of XLS(X) files with missing trailing cells on some rows.

7.2.14

• Fixes bug that causes the PUT /{parentType}/{parentId}/children to fail if parent is a SLC.

7.2.13

• Increases inprocess database connection pool from 8 to 30 to allow more parallel requests.

7.2.12

• Improves timeout behaviour on MySQL Data Sources.

7.2.11

• More accurate result row estimate function for data sources and data queries.
• Supports date trunc functions like month() and day() on MySQL as well.

7.2.10

• Fixes time zone and daylight saving time issues on MySQL connections.
• Provides ISO-8601 formatted times in the timezone of the web service instead of UTC (e.g. 2023-01-02T08:00:00+01:00 instead of 2023-01-02T07:00:00Z). This is much easier to read when working with the webservice and should not affect existing clients as those should always factor in the offset.

7.2.9

• Also estimates row count on MySQL to improve query performance.

7.2.8

• Correctly handles JSON operators ?, ?| and ?& in data queries.

7.2.7

• Fixes handling of zoned date time params.

7.2.6

• Fixes a bug that breaks PDF reports containing special characters in the footer fields.

7.2.5

• Fixes broken position marker if data query contains errors.

7.2.4

• Fixes deadlock when a slow data query is accessed multiple times in parallel.

7.2.3

• Limit columns in data source /columns to current schema.
• Fixes loading of data source scopes.

7.2.2

• Fixes a bug that breaks requests to data sources and data queries that contain quotes in search query values.
• Fixes data queries on databases that do not allow creating the cache schema.

7.2.1

• Listens on all IPv4 and IPv6 addresses instead of only IPv4.

7.2.0

• Allows to modify table schemas of data sources
• Allows to change data of data sources
• Implements annotations
• Changes representation of revaluation active time that begin only contains the local time component instead of a full ISO-8601 string.
• Refresh interval for materialized data queries.

7.1.3

• Fixes a bug that causes /{type}/{id}/children requests to fail in case an object contains Alarmrecepients.

7.1.2

• Data Sources
  • Fixes row number estimate in case of query contains IN() conditions.

7.1.1

• Script data source
  • Fixes bug that causes error if offset is greater than number of returned rows.

7.1.0

• Rejects values provided to /webcollector that are too far in the future
• Estimates number of rows fetched from PostgreSQL databases instead of calculating it if the number of fetched rows is greater than 1'000'000. This massively increases query performance on big datasets.
• Fixes bug that causes fetching job messages to fail if an object is not scheduled on a collector.

7.0.7

• Data Queries
  • Fixes deadlock when refreshing nested data queries.
  • Fixes a bug that causes dependency resolution to find the same dependent multiple times.

7.0.6

• Provides defaultParams in /dashboards/groups/nested request

7.0.5

• Fixes bug that causes a select request on a script data source to crash if no offset and limit params are provided.
• Fixes parsing of data queries containing with

7.0.4

• Inventory Controller
  • Fixes handling of tree request with empty objects.

7.0.3

• PDF Reports
  • Also fixes page wrap for tables

7.0.2

• PDF Reports
  • Fixes page wrap
  • Fixes doubled table headers

7.0.1

• Allows to export single data query
• Fixes a bug that sometimes prevented detecting already materialized data queries upon service restart.

7.0.0

• Improves data queries
  • Allows to materialize data queries similar to materialized views.
  • Remove Semver versions in favour of just dates.
  • Improves reference detection.
  • Enforces permissions from data source in dmvn testata query as well.
  • Caches data query results for better performance.
• Pools PDF report rasterizers to improve performance.
• Updates MySQL JDBC connector. Requires MySQL >= 8.
• Adds InventoryController which provides optimized endpoints for the SKOOR Dashboard Inventory widget

6.4.3

• Mainteneance release to incorperate changes from 6.3.4.

6.4.2

• Supports PostgreSQL citext type and (more) other special types as well.

6.4.1

• /files endpoint now defaults mime type of unknown files to application/octet-stream instead of returning null.

6.4.0

• Allows to delete files using DELETE /files/filename.extension
• Increases maximum upload file size from 1 MB to 10 MB

6.3.4

• Ensures that PostgreSQL connections always use the external connection pooler.

6.3.3

• Ensures that the current user has full permissions on a newly created dashboard group.

6.3.2

• Speeds up Webservice startup by triggering migrations only once during update.

6.3.0

• Allows operators like AND(), OR() when doing text search on data sources
• Sorts reasons naturally when getting origin (drilldown)

6.2.5

• Fixes creation of dashboard groups

6.2.4

• Normalizes Dashboard permissions
  • Makes root "Dashboards" readable by any
  • Adds "Deny Any" to root "Dashboards" group for referenced objects
  • Removes "deny" rules fom all dashboard objects

6.2.3

• Forces init permissions of dashboards to parent object

6.2.2

• Fixes Dashboard fetching when user is moved into other groups or changes role.

6.2.1

• Fixes Header Tile migration in case og only right header tile.

6.2.0

• New Dashboard permission endpoints

6.1.4

• Fixes Data Queries using aggregate functions without alias (e.g. count(*), sum(foo), ...)

6.1.3

• Does dashboard migrations once per tenant instead of only once globally.

6.1.2

• Data Queries
  • Fixes data queries that have deleted user as author.
  • Fixes Data Queries with null query strings

6.1.1

• Data Queries
  • Does not use Commont Table Expressions on MySQL because old version of MySQL do not support those. Probably there will be a detection for this feature in a later Webservice version.

6.1.0

• Data Queries
  • Usees Common Table Expressions (WITH queries) for sub queries instead of nested sub queries. No need to add an alias to a sub query anymore.
  • Strips comments before processing sub queries and params.
  • Measures query execution time and return duration
  • Allows default values for parameters and simplify parameter syntax (no more "params.")
• Data Queries / Data Sources
  • Sub aggregates
• Styles endpoint for storing custom CSS styles
• Returns children in reason call

6.0.5

• Fixes reading config from environment variables

6.0.4

• Data Queries
  • Removes pinning logic
  • Always deletes groups recursively
  • Simplifies and fixes export/import

6.0.3

• Returns a 404 instead of 500 HTTP status code in case of invalid dashboard

6.0.2

• Allows to save invalid data queries. Return errors when getting data query instead
• Does not add version markers anymore when publishing data queries
• Fixes circular reference detection for sub data queries

6.0.1

• Single request for dashboards including its children (/dashboards/{id}/nested)

6.0.0

• Config from ENV
• Allows to set darkmode on user
• Many changes when getting dashboards
• Removes some stuff now done by SKOOR Auth
• Uses connection pool from PGPool-II if available