October 2025

This release introduces major improvements to forms, filtering, AI capabilities, and security. Key highlights include extended identifier lengths, a unified Filters system, a fully integrated MCP server with AI-accessible tools, optimized record updates, and enhanced 2FA support. Additional usability, UI, and infrastructure enhancements further improve performance, reliability, and developer workflows.


Forms

Extended Identifier Length

Form and form component identifiers can now have up to 30 characters (previously limited to 8). Identifiers cannot contain "__" (double underscore). All the other naming rules stay unchanged.

UI & Usability updates

Glossary

A list of Clients was added to the Glossary form, along with auxiliary texts clarifying its functionality and intended use.

Text Translations

The "Translate All" button in the Texts menu was replaced with a "Check Untranslated Texts" button, which redirects users to the Untranslated Texts menu. The "Translate All" button is now found within the Untranslated Texts lists. Clicking an untranslated text opens the same translation form used for local translations. The "404 record not found" error was also fixed, resulting in a more consistent and reliable translation process.

Table Fields

A simplified Field form is now used when inserting or opening a Table Field from the Quick Access menu or the Table details form, enabling faster edits. The detailed Field form stays accessible through the “Field Details” button and the Table detailed form.

Color Coding for Tables, Forms and Menus

Distinct colors were introduced to improve visual orientation:

  • Orange for Tables
  • Green for Forms
  • Blue for Menus

These colors are now applied to the Quick Access menus and main forms, making navigation more intuitive.

Form Component Classes

Form component classes were renamed and reorganized to improve clarity, modernization, and standardization. The following classes were merged:

  • Flash control Chart and External application -> Advanced / Interactive (ADV)
  • Static and Filter -> Data Display (DSP)

This restructuring sets up a clearer foundation for future form component types.

Markdowns for Help Texts

It is now possible to use Markdown formatting to create detailed help descriptions, improving readability and ease of use.

Filters

Usability improvements

All separate filter types have been unified into a single "Filters" system.

  • Static filters are now included in the Filters configuration popup.
  • Filters can now be created and managed in a unique location.
  • All filters are displayed in the popup, regardless of whether they were created via a column search, the search bar, or other methods.
  • The conditions (AND/OR) between filters are clearer. The following improvements were introduced in the lists:
  • Sorting can now be changed by clicking directly on a column header.
  • Filtered columns are visually highlighted with a darker header background.
  • Filter badges have been standardized, cutting earlier differences in types, colors, and click behavior.

MCP & AI Capabilities

MCP Server

A complete MCP server was implemented, exposing database CRUD operations and custom business logic as AI-accessible tools, fully compliant with the official MCP specification. This provides a unified, context-aware chatbot across all Genio applications with natural conversation commands while keeping the same security and validations.

Tool Support

The following tool types are supported:

  • CRUD Tools – Create, Read, Update, Delete operations
  • List Tools – Filtering, sorting, and pagination
  • Manual Tools – Custom tools defined using the MCP_TOOL tag

Tools are generated and managed directly within Genio.

Security

Two security modes are available in WebAdmin:

  • JWT (default) – Authenticated requests using a context-aware JWT token
  • None (testing mode) – Permissionless mode for local testing environments

This implementation enables secure and standardized AI integration with Genio.

RAG Management

RAGs introduced in the GAI Portal allow users to upload documents for GenioBot to retrieve information from, generating more accurate and up-to-date answers.

Supported file types: PDF, DOCX, JSON, CSV and TEXT. Maximum file size is 50 MB.

Two Factor Authentication (2FA)

2FA is now fully integrated as standard Identity Providers, simplifying configuration and management across Genio. Existing XML configurations are automatically migrated to the new format, and providers can now be explicitly set to require 2FA. The WebAuthN library has also been updated to .NET 8, which is available for VueJs-based servers. The 2FA interface has been improved with multiple fixes, enhancing both registration and authentication workflows.

Record Update

Record update operations have been optimized to reduce SQL bandwidth, parsing overhead, and potential locking issues. Fields now track their database value separately from their in-memory value using OldValue (last value from the database), IsBookmarked (true if the value was read from the database), and IsDirty (true if the in-memory value differs from the database).

Areas also track whether bookmarked values were read with an update lock (IsBookmarkLocked), allowing search and update operations to avoid unnecessary re-reads of old values. PersistentSupport methods now set OldValue automatically, enabling framework-wide IsDirty() checks, while update methods only include changed fields. Search methods support a new updateLock parameter, which improves efficiency for formulas, manual routines, and Change operations that already have parent row data.

These improvements reduce locking scope and queries, with unit tests showing a 10-20% reduction in query count and improved deadlock prevention.

Jenkins scripts generation

It is now possible to generate Jenkins scripts on GenioWeb. Configuration path: Menu Generation->Generate Client Applications -> Generation Type (dropdown)

Database & Infrastructure

Primary Key Management

Added support for a new WebAdmin Extra Property, "SYS_PK_SEQUENCES", allowing the use of database sequences instead of the "Codigos_Sequenciais" table for primary key management.

Important bugfixes

  • Fixed field generation in MergeNN calls to consistently use the database schema name for all fields. Previously, the schema name was applied to only one field, causing runtime errors.
  • Standardized VARCHAR lengths in DropFk.txt.vm to prevent truncation issues during reindex operations.
  • Fixed an issue preventing SU menus from functioning properly.
  • Resolved an issue where the Dashboard Widgets tab could not be closed.
  • In multiselect lists, using the "Select all" option now correctly displays "All rows selected" instead of an incorrect number of rows.
  • Added the missing zzstate condition to LED component searches, preventing invalid records from being selected through autocomplete.
  • Fixed a conversion error occurring in Logic fields with default values when populated via PHE.
  • Fixed an issue where adding new advanced filters did not mark the table configuration as requiring saving.
  • The User object no longer populates the Year property. Validation now relies on the Years list property to determine authentication years.