• New Input Elements:

  • Code Field: New code input element for code editing
  • Radio Button Input: Added radio button input element for single-choice selections
  • Interval Input: Enhanced interval data type support across the platform

• UI Components & Layout:

• PDF Reporting:

  • Added a new page type for reports, allowing users to generate PDFs directly from the application

  • Introduced Interactive and Static PDF Report Generation with LaTeX support for structured reports.

• Application Management & Usability:

• PDF Reporting:

  • Added a new page type for reports, allowing users to generate PDFs directly from the application

  • Introduced Interactive and Static PDF Report Generation with LaTeX support for structured reports.

• Application Management & Usability:

This section will describe the most important aspects of CYPEX terminology.

In CYPEX you use existing SQL models to build new and powerful applications. The first term we need to discuss is the idea of an “entity”. We use the same semantics as in a standard relational model: an entity is a table which is tracked by CYPEX. All tracked entities will be part of the GUI prediction which is made based on the data structure. If an entity isn’t tracked by CYPEX, it won’t be included in that prediction.

• Add the ability to set admin roles & others.
• Configure JWT token expiration.
• See Application owner on edit App page.
• List materialized views in the database overview.

• Several fixes on Create Queries.
• Translation fixes.
• UI fixes.
• Upate Application repository default Token.
• PGRST reload schema event on DDL Actions.
• UI Editor: fix error when removing all actions from a table.

• User-Friendly Geo JSON Editor: introducing a new, user-friendly Geo JSON editor that simplifies the process of editing and managing Geo JSON data.

• Custom Expression Editor: Added a custom expression editor that is now expanded in a modal window, enhancing the user experience by providing a more spacious and focused environment for creating and managing expressions.

• Workflows Enhancements: Implemented Swagger (SWG) and LaTeX endpoints for improved API documentation and reporting capabilities.

• Application Configuration:

  • Added functionality for changing the application logo, enhancing brand customization.

  • Introduced the ability to set the uploaded file name within the Admin panel, streamlining file management.

• Ability to drag&drop query into the query group.

• Application creation: query selection tree and query description.

• Demo data for CYPEX trial version.

• Enable/disable autocomplete element via custom expression.

• Fix current_user and current_role functions to work also in old PostgreSQL versions.

A workflow is a good start if you want to build an application. However, sometimes it’s still necessary to add control elements. In this section, you’ll learn to add buttons and to write server side code to make your application even more powerful. Starting with v1.9.0 CYPEX offers an approach to create database functions directly within its interface. The REST API behind the scenes executes these functions, providing a unified experience for managing both data and logic.

• Backend Refactor.

• Added translation to the Query group.

• Enhanced Workflow UI.

• Button to create a new record moved to a default table config.

• Resolved bugs impacting Workflow transitions.