Stable version 1.0.1 (Compatible with OutSystems 11)

Uploaded

on 3 Nov

0.0

(0 ratings)

Details

Dynamic CRUD Validator automates data validation in CRUD operations by dynamically generating validation rules based on your database structure. Leveraging Entity and Entity_Attr, it applies checks for required fields and text length, ensuring data integrity without manual coding. Ideal for large tables in legacy systems or high-stakes applications, it adapts to changes automatically, saving time and boosting accuracy. Perfect for developers looking to streamline data validation, with opportunities for community contributions to enhance its functionality.

Dynamic CRUD Validator is here to take the pain out of data validation for CRUD (Create, Read, Update, Delete) operations in OutSystems. By tapping into OutSystems’ own system entities, Entity and Entity_Attr, this component dynamically builds validation rules tailored to your data model’s structure. No more tedious manual checks or custom logic for every CRUD action—Dynamic CRUD Validator handles it all and keeps your data clean and consistent.

CORE FUNCTIONALITY

Automated Data Validation: Fetches metadata from Entity and Entity_Attr to apply checks on data types and required fields.
Dynamic Rule Generation: Reads your data model in real time, adapting to any changes so you don’t have to update validation rules manually.

KEY FEATURES

Seamless Data Integrity: Automatically validates fields to meet conditions like mandatory fields and text length constraints, ensuring your data stays accurate and consistent.
Better Data Security: Reduces risk by stopping bad data from ever entering the system, keeping your data accurate and secure.
Less Manual Coding: Speeds up development by eliminating repetitive validation code across CRUD operations.
Automatic Adaptability: Adjusts to changes in the data model automatically, making it perfect for apps that need to grow and scale.

USE CASES

Legacy Data Migration: Ideal for applications using legacy databases with tables that contain a large number of fields, where manual validation would be cumbersome.
Enterprise-Grade Applications: Great for high-stakes apps where data accuracy isn’t optional, like finance or healthcare.

Dynamic CRUD Validator is here for OutSystems developers who want to save time, minimize manual effort, and boost data accuracy in their apps. If you’re looking for an easier way to keep your data clean, this component does the heavy lifting for you.

And if you have ideas to make it even better, I’d love for you to jump in and contribute. Let’s make data validation smarter and

Release notes (1.0.1)

Version 1.0.1 - Update to Support External Databases

New Features & Enhancements

Enhanced Validate Action Parameters:
- ExcemptedAttributeNames (List<Text>): A new optional parameter that allows developers to specify a list of attributes that should be excluded from validation. This provides more control over which fields are validated and can help streamline processes by omitting unnecessary checks.
- ESpaceName (Text): The ESpaceName parameter is now optional, as external entities do not belong to any specific eSpace. This change ensures that the component can handle validations for both internal and external entities seamlessly.
- IsExternal (Boolean): A new parameter to support validation of entities located in external databases. When set to True, the component will look for the entity in external databases registered within the OutSystems environment.
- LogicalDatabaseName (Text): When IsExternal is set to True, this parameter allows you to narrow down the search by specifying the logical database name. This helps in accurately identifying the external entity when multiple databases are present.
Support for External Databases:
- This update enables the component to validate entities in external databases, expanding its applicability beyond internal data models. External databases are registered differently within the Entity system entity, so this enhancement ensures compatibility by adjusting the search and validation process accordingly.

Bug Fixes & Optimizations

Improved performance when validating entities with a large number of attributes by optimizing the validation flow.
Minor adjustments to error handling to provide more descriptive messages when validation issues are encountered.

Notes for Developers: These enhancements make Dynamic CRUD Validator more versatile and compatible with external databases, providing greater flexibility for OutSystems applications connected to external data sources. The optional ExcemptedAttributeNames parameter also adds new possibilities for custom validation flows by allowing specific fields to bypass validation as needed.

This update supports more complex data architectures, enabling smoother validation processes in applications that span internal and external databases.

License (1.0.1)

BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)

Reviews (0)

Team