Docs

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