ListCompare&ValidationUtility - Overview (O11)

version 1.0.0 (Compatible with OutSystems 11)

Uploaded

on 13 Aug

5.0

(1 rating)

Details

List Compare & Validation Utility is a reusable extension that compares two text lists and provides detailed validation results. It helps developers identify matching, missing, extra, and duplicate values between lists while supporting configurable comparison options. Key features include: Compare two text lists for equality Ignore case differences (e.g., "ABC" = "abc") Ignore leading and trailing spaces Ignore empty values Compare lists regardless of item order Optionally ignore duplicate values Return summary statistics and detailed comparison results The component returns: Whether both lists are equal Total item counts in each list Number of common values Values found only in List A Values found only in List B Duplicate counts in each list Detailed item-by-item comparison status Typical use cases: Batch number validation Shipment and invoice reconciliation Excel import verification Data migration validation Master data comparison Integration and API response validation Quality checks during data processing This utility is designed for high performance, easy integration, and reusability across OutSystems applications, reducing the need for custom list comparison logic in every project.

Overview

List Compare & Validation Utility is a reusable OutSystems O11 extension that provides advanced comparison and validation capabilities for text-based lists. It enables developers to quickly determine whether two lists contain the same values and identify differences such as missing items, extra items, duplicate entries, and common values.

The component is designed to simplify data validation scenarios commonly found in enterprise applications, integrations, imports, exports, logistics systems, warehouse management, ERP integrations, and data migration projects.

Key Features

? Compare two text lists

? Detect matching and non-matching items

? Ignore case differences

? Ignore leading and trailing spaces

? Ignore empty values

? Compare lists regardless of item order

? Optionally ignore duplicate values

? Return detailed comparison results

? Return summary statistics

? Easy integration with Reactive Web, Traditional Web, and Service Actions

? Optimized for OutSystems O11 applications

Supported Comparison Options

The component provides configurable comparison behavior through input parameters:

Option	Description
IgnoreCase	Treats "ABC" and "abc" as identical values
TrimSpaces	Removes leading and trailing spaces before comparison
IgnoreEmpty	Ignores empty or blank values
IgnoreOrder	Compares lists regardless of item sequence
IgnoreDuplicates	Ignores duplicate values during comparison

Outputs

The utility returns a summary result structure containing:

Output	Description
IsEqual	Indicates whether both lists are considered equal
ListA_Count	Number of items in List A
ListB_Count	Number of items in List B
CommonCount	Number of values found in both lists
OnlyInListA_Count	Number of values only found in List A
OnlyInListB_Count	Number of values only found in List B
DuplicateListA_Count	Duplicate item count in List A
DuplicateListB_Count	Duplicate item count in List B

Additionally, a detailed comparison list is returned showing:

Field	Description
Value	Compared value
Status	Common, OnlyInListA, or OnlyInListB
CountInListA	Number of occurrences in List A
CountInListB	Number of occurrences in List B

Example

List A

A1
A2
A3

List B

A1
A2
A3

Result:

IsEqual = True
CommonCount = 3
OnlyInListA_Count = 0
OnlyInListB_Count = 0

Details:

Value	Status
A1	Common
A2	Common
A3	Common

Release notes (1.0.0)

License (1.0.0)

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

Reviews (0)

Team

Other assets in this category

Deprecated: Uses outdated OutSystems development patterns. eCommerce is an online store web application sample. It includes a storefront web application and a management back-office that you can completely customize.

4062

The frantic run of the valorous rabbit...

Have you been working remotely for quite a while now? Missing the drinks, bites and fun with your colleagues? Well, I can't help with the drinks and bites... But I can help with the fun! This application will allow you the play Werewolves remotely. Please refer to the internet for the rules, refer to the detailed description for how to use the application.