v2.0.0 is the release in which CYPEX becomes a multi-tenant PostgreSQL application platform. Tenancy is a first-class object (Organizations), isolation is enforced in the database (Row-Level Security), authorization is two-dimensional (Capabilities × Data Scope), schema exposure is explicit (Schema Access), identity can be federated (SSO Gateway), and outbound integrations are governed (allowlist, credentials, enablement, audit).

Warning

This is not a drop-in patch. v2.0.0 changes the permission and tenancy model. Read the Upgrade to v2.0.0 operator guide before planning a maintenance window, then the Upgrading to v2.0.0 technical reference for the database detail.

A CYPEX deployment can serve more than one tenant — an Organization — from the same PostgreSQL database. Isolation is enforced by Row-Level Security in the database, not by UI filtering.

• 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:

  • Icon Element: Configurable icon element with customization options
  • Background Image Support: Added background image configuration for UI pages
  • Configurable Default Container: Enhanced default container with adjustable configuration
  • Modal Button Configuration: Added hidden state and size settings to modal buttons
  • Enhanced Conditional Container: Added toggle functionality to conditional containers

• Data Visualization & Charts:

• 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:

  • Merge Applications: Admins can now merge multiple applications built for the same user role using the Published Release or the Last Save Point, enhancing team collaboration and feature integration.

• 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.

  • Enabled support for SSL connections, ensuring secure data transmission.

• User Interface Improvements:

• 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.

• 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.

• Copy table element bug.

• Admin Panel - broken Query filter.

• Upgrade PostgreSQL database & postgREST docker images to the latest version

• App description as translated markdown text

• Implement permission assignment on default queries

• Trial version for the demo purpose

• Groups for queries - Admin panel

• Application Extension: support company internal repository urls

• Admin Panel: Added filter by query type

• Autogenerate Input Fields for the Form Element

• Added the confirmation modal to delete query

• Display referenced data in the array feild

• Provide repository connection to API container via proxy

• Fixed form errors preview

• Deleting a default query removes other queries from different database schema