Skip to content

Change Log

Release notes for the latest updates and features in the platform. Version numbers not listed are internal releases: related to Fixes, library updates, security updates, and minor platform improvements.

Wording

  • Added: New features.
  • Changed: Modifications to existing functionality.
  • Removed: Features that have been removed or are soon to be removed.
  • Fixed: Bug fixes.
  • Security: Improvements related to security.
  • Breaking: Changes that may require modifications to existing applications.

Areas

  • CORE: Core platform features.
  • MESSAGING: Emails, comments, and notifications.
  • DAM: Digital Asset Management and file management.
  • ACCESS: Access control, roles, teams, and users.
  • SRS: SRS, SQL, and data transformations.
  • DEVOPS: Related to development and CI/CD (Continuous Integration/Continuous Delivery).

Road Map

  • SRS
    • additional schema validations: pre validations ex. duplicate jet file, sql syntax pre check
    • simplified onboarding for new developers
    • improved sql parameters type discovery
    • improved built in git server when system is not connected with SCM
    • VDB2 virtual db support, to more flexible data transformation and build in fulltext search
  • STORAGE excel as json , file as SRS parameter
  • ACCESS new device / location,device management / unified two factor authentication
  • Naming - unified api naming paanda to jetQuery - jet file (xml file), jet engine (api) , api/srs to api/jet ,

2305 2024-12-17

  • DEVOPS/Added schema comparator support for custom scripts for selected databases just place script in \db\!custom\[[db_name]]
  • DAM/NEW excel to json (support embeded images), excel to xml (support embeded images), xml to json macros

2301 2024-12-12

  • SRS/Fixed ordering datasets and colors when dtsplit appplied
  • SRS/Fixed html export hide empty columns
  • SRS/Added session_id is now UUID v8 with SQL Server compatibility, session_id can be reused as parameter
  • DEVOPS/Added schema comparator support for renaming objects during deploy
  • CORE/Added simplified configuration, default system connection inherit from instance connection
  • SRS/Changed better handling mutliple isolation levels on connections

2298 2024-12-02

  • CORE/Changed Updated core libraries to the newest version (9)

2296 2024-11-30 Breaking

  • CORE/Changed Rewrote the JSON engine for improved performance and reduced memory consumption (approximately 20% improvement in both).
  • CORE/Changed Unified default date and time formats
    • "date": "2024-12-27T00:00:00" → "2024-12-27"
    • "time": "02:08:15.9133333" → "02:08"
    • "smalldatetime": No changes ("2025-01-02T09:29:00")
    • "datetime": "2025-01-02T09:29:15.913" → "2025-01-02T09:29:15"
    • "datetime2": "2025-01-04T11:39:15.9133333" → "2025-01-04T11:39:15"

2289 2024-11-13

  • DEVOPS/Changed Unified comparison and scripting for comparing work with "Create Table" scripts.
  • DEVOPS/Changed Added a new comparator type: db-data-sync for updating configuration and data

2287 2024-11-10

  • DAM/Removed deprecated file apis /api/core/files/r
  • DAM/Removed changed ZIP compression library for better security and performance
  • DAM/Added support for remote paths in file api /api/core/files/[file_uuid].xpath
  • DAM/Changed unified support for registered files in /api/core/files/[file_uuid].xuuid
  • DEVOPS/Added dedicated api for analyzing usage of srs endpoints
  • DEVOPS/Changed extended api for schema comparison, and new macros db-column-sync for syncing column properties and db-table-exist for table existence checks
  • SRS/Fixed edge case when custom data type was defined in sql server, and the column properties was not recognized in SRS

2284 2024-10-22

  • DEVOPS/Added application changelog endpoint /api/core/apps/scm-log/{app_name} requires the sys_info role and proper application access.
    • The changelog provides a daily summary of changed objects in an anonymized format and Commits prefixed with CL
    • The list of commits includes a simplified description

2283 2024-10-22

  • MESSAGING/Added EMAILS Check for attachments presence before sending emails and better error information

2282 2024-10-10

  • SRS/Added HTMX enhanced support srs If renderer html return html
  • SRS/Added HTMX enhanced support srs If renderer html and message return message
  • SRS/Added param label inherited from global scope
  • SRS/Fixed FIXED empty json-xml-root json-xml

2279 2024-10-07

  • SRS/Added new command opts keyword - pscope, if specified pscope required in query for command to execute
  • DEVOPS/Added - dev/ops experimental db-column-exist db-index-exist actions

2274 2024-09

  • SRS/Added label and title is inherited form global scope if missing in srs properties xlabel and xglobal are assigned for definitions inherited from the global scope

2273 2024-09 Breaking

  • SRS/Added itm/column/opts new property uianonymize for anonymizing data in the UI.
  • SRS/Added throw an error if a parameter or command is added to the global scope.
  • CORE/Added Authentication API unification (authenticate returns unified message data.jwttoken instead of content) for easier integration with applications.

2269 2024-09

  • SRS/Added SRS frx,hbs better cache support in hbs,frx templates
  • SRS/Fixed SRS frx data binding issue leading to not refreshing data

2266 2024-09-04

  • CORE/Added api message standardization for non standard validation messages
  • CORE/Changed improvements in FormContentType detection and conversion
  • CORE/Changed /api/core/meta/get/* structure standardization
  • CORE/Removed /api/core/meta/tag/* removed obsolete api

2264 2024-09-03

  • MESSAGING/Added new property mail_team_id support for teams in outgoing mails
  • MESSAGING/Added new property mail_sent - sent confirmation for outgoing mails
  • MESSAGING/Changed better messageid support

2262 2024-08-28 Breaking

  • ACCESS/Changed user object standardization

Migration:

  • lowered case ( phoneNumber,UserName,emailConfirmed,lockoutEnabled,lockoutEnd,lockoutEnding,lastActivity)
  • API affected: /api/core/account/profile model to user - lowered case
  • API affected: /api/core/account/browse - lowered case
  • $root.sys.profile: lowered username case

2261, 2024-08-27 Breaking

  • MESSAGING/Changed: messaging/comments v2
    • subject, template can be diverse for each message
    • data object now store subject and template of the message
    • Security improved security
  • CORE/Fixed using reserved file name, result in application error output.min.css, now it's working as expected

Migration:

  • comment_email_subject changed to comment_subject in POST {{host}}/api/core/comments
  • modified json structure to standard msg structure GET {{host}}/api/core/comments/browse ex. list:[] to "data": { "list": []}
  • modified json structure to standard msg structure GET {{host}}/api/core/subscribers/browse

2259 2024-08

This version significantly simplify interaction with the API from native Mobile Applications and other tools for example Python.

  • CORE/Added: Simplified general API interactions, with the default application/json content type and other enhancements.
  • CORE/Added: Support for HTML forms across the entire API, making interactions from tools like htmx much easier.
  • CORE/Added: Enhanced ping API with body support for improved testing.
  • CORE/Added: Enhanced security through encryption of internal communications in jobs.
  • CORE/Changed: Enhanced support and security for multiple subdomains.

2258 2024-08

  • MESSAGING/Changed emails v2, improved support for multiple mailboxes and mail providers for incoming and outgoing mail
  • SRS/Fixed SRS Fixed issue with query string not overriding body parameters - docs
  • CORE/Added Tools vies/vat built in support for EU VAT validation V2

2254 2024-07 Breaking

  • CORE/Removed api/core/teams/user - removed obsolete api
  • CORE/Removed api/core/roles/user - removed obsolete api
  • CORE/Removed api/core/teams/teammate-status - removed obsolete api
  • CORE/Changed api/core/account/profile Simplified and extended with app, teams, roles
  • CORE/Changed api/core/teams/create/{team_name?} use api/core/teams/set/{team_name?} instead
  • CORE/Removed api/core/apps/browsev2 - removed obsolete api
  • CORE/Removed api/core/files/user - removed obsolete api

2244, 2024-06 Breaking

  • SRS/Changed SRS Data Transformations
    • dtsplit - Converts a single command into multiple commands.
    • dtsingle - Depending on the renderer, returns an object or dtpivot-cols.
  • SRS/Added dtpivot-cols - SRS Data Transformation, transposes columns to rows.

Migration:

  • type="header" replaced with opts="dtsingle".
  • type="single" replaced with opts="dtsingle".
  • type="pivot" replaced with opts="dtpivot-cols".
  • opts="pivot" replaced with opts="dtpivot-cols".
  • opts="matrix" replaced with opts="dtsplit".
  • opts="single" replaced with opts="dtsingle".

2243

  • DEVOPS/Added Schema validation against the master schema for selected database objects

2239

  • SRS/Changed Printing performance improvements and enhancements
  • SRS/Changed Auto printing generator improvements

2236

This version introduces a additional layer to manage ACLs in SRS srssetup can be used to run business logic before the SRS is executed. Any errors in srssetup will stop the execution of the SRS. This allows for additional security checks and simplifies ACL management in complex SRS.

  • SRS/Added srssetup now has access to parameters.
  • SRS/Added srssetup errors now stop the execution of the SRS.
    • This change is to prevent the SRS from executing if there are errors in the srssetup section.
    • Change greatly simplify ACL management in complex SRS, simplyfy SRS commands, allow for additional security checks depending on bussiness logic.

2234

  • SRS/Added - VDB - virtual db support V2 including full text support for database queries. All DB queries can be converted to FullText queries.
  • CORE/Changed - UI - standardization - hidden elements type=hidden uihidden replaced with lg=false

2231

  • SRS/Changed enhanced automatic support for transaction isolation levels in Sql Server, included snapshot isolation level opts="ts-snapshot"

2230 Breaking

  • CORE/Changed: simplified routing, improved remote developer experience, flexible routes, support for local images, and html, etc. First support for HTMX language.

Migration:

  • path /client/images......... to /images
  • path /cssOndemand/ to /assets/css
  • path /jsondemand/ to /assets/js

2229

  • CORE/Changed: UI global error handling
  • CORE/Fixed: manifest.json errors
  • CORE/Breaking: CORE Cleanup of the codebase, remove unused api endpoints, baskets,docs,tasks,transactions, apps/home
  • CORE/revert: CORE /api/core/files/{guid} from /api/core/files/get/{guid}

2228

  • CORE/Changed: Support for command timeout and connection timeout

2220 Breaking

  • CORE/Changed: /pages no longer creates auto routes. Use routes.push at the end of the component instead.
  • SRS/Changed: SRS Optimization of data.json.
  • SRS/Added: SRS new error handling for SQL errors and massaging
  • CORE/Changed: Performance improvements in bundling and caching.

2211

  • CORE/Changed barcode, qr code support moved to core,

2206 Breaking

  • SRS/Changed: SRS data.json default naming for properties changed to data source names case for consistency, previous naming was lowercase, lowercase naming is still supported [name].lower.json
  • CORE/Changed: API endpoint is deprecated /api/core/files/{guid} has been changed to /api/core/files/get/{guid}.

2205

  • SRS/Added tbase64 support in SRS for images, with optional width, height, and optimization parameters.

2193

  • CORE/Changed Numerous general important performance improvements, giving around 30% better performance globally, and 20% better resource utilization.
  • CORE/Changed moved to .NET8

2188

  • DAM/Added: Optimized images are now stored in the application storage .
  • DAM/Added: MOV files can be deleted. If there is an MP4 file with the same name, it will be used instead.

2186

  • DAM/Added: Implemented ETag support in client files.
  • SRS/Added: SRS Implemented ETag support in client files.
  • CORE/Changed: Disabled default www and static files endpoints. Client files are now only available through /client.
  • CORE/Changed: Switched to System.Data.SQLite, resulting in around 50% better performance with SQLite.
  • CORE/Changed: Overall performance improvements of around 20% globally.

2180

  • CORE/Added: Support for multiple domains in hosting. Use hosting_domain separator.
  • CORE/Changed: API Unified API naming conventions.
  • CORE/Added: CLI command support in jobs.
  • CORE/Added: New custom query for logs.

2174

  • CORE/Added: Implemented ETag support in SRS, files, and storage. The ETag is an identifier for a specific version of a resource, improving caching efficiency and saving bandwidth by avoiding unnecessary data transfers.

2170 Breaking

  • SRS/Changed: structure dsn="system"is no longer required, there is default connection on application level
  • SRS/Changed: dsn=" to link=", used only in the case of a command.
  • SRS/Added: link can now be used as:
    • model="command" - as the name of the DSN.
    • model="param" - as the URL for data fetched from the API.
    • model="option" - as the URL.
    • model="column" - as the URL.
  • SRS/Changed: All options should be specified as tags in the opts attribute.

Migration:

  • dsn="self" to link="self".

2153 Breaking

  • SRS/Changed: SRS title to label in <srs title=" to <srs label=".
  • SRS/Changed: SRS simplified schema.
  • SRS/Changed: SRS will now throw an error if no command to execute is specified after logic is executed.
  • CORE/Changed: UI upgrade with more consistent tags, improved settings navigation, and more.
  • SRS/Added: SRS Data Transformation for commands to generate multiple tables using <itm opts="matrix"></itm>.
  • SRS/Changed: Simplified SRS schema - Changed tags to opts in the itm section for consistency with other sections.
  • SRS/Added: SRS audit in terms of security and access control srs/5000
  • SRS/Changed: SRS will now throw an error if no command to execute is specified in scenarios
    • SRS has multiple command elements for different actions (e.g., insert, update, delete).
    • Each command has an acl attribute specified.
    • SRS is executed with a pscope parameter to limit results to one action.
    • If the user has no access to the action specified in the pscope parameter, the SRS will throw an error with the message "Nothing to execute or no access". Previously, it would return success=true.

Migration:

  • type="server" to opts="server".
  • type="job" to opts="job".
  • req="true" to opts="req".
  • type="header" to opts="single". Header is now obsolete.
  • type="single" to opts="single".
  • type="pivot" to opts="pivot".
  • tags=" to opts="