Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Registers Gateway

TABLE OF CONTENTS

Consolidation configuration for sortAppendedValues

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedAug 04, 2026
  • 2 minute read

The sortAppendedValues setting is a configuration option within the InfoInterface:Consolidation element that controls whether attribute values appended via the DuplicateAttribute={geicl:notderivable}append configuration are automatically sorted in alphabetical order.

This feature ensures consistent ordering of appended values across registers, enabling accurate attribute comparisons and reliable change tracking in Enterprise Data Warehouse (EDW).

Configuration syntax

Add the sortAppendedValues attribute to the InfoInterface:Consolidation element in your ClassLibrary file:

<InfoInterface:Consolidation

geicl:id="Consolidation"

sortAppendedValues="true"

xmlns="http://schemas.aveva.com/InformationInterfaces/Extension/Schema/2017/0 4" />

Attribute Reference

The following table lists the attribute reference:

Attribute Name

sortAppendedValues

Data Type

Boolean

Default Value

false

Allowed Values

true | false

Required

No (Optional)

Behavior

When sortAppendedValues="true"

  • All values appended via DuplicateAttribute="{geicl:notderivable}append" are automatically sorted in alphabetical (ascending) order.

  • Sorting is applied after all values are collected and before the final attribute value

  • is written.

  • Consistent ordering is maintained across all registers using the same configuration.

When sortAppendedValues="false" (Default)

  • Values are appended in the order they are received/processed.

  • No sorting is applied to the appended values.

  • Order may vary depending on source data processing sequence.

Example

Consider an attribute receiving duplicate values from multiple sources:

Scenario

sortAppendedValues="false"

sortAppendedValues="true"

Register A receives: PID-002, PID-001, PID-003

PID-002; PID-001; PID-003

PID-001; PID-002; PID-003

Register B receives: PID-001, PID-003, PID-002

PID-001; PID-003; PID-002

PID-001; PID-002; PID-003

With sortAppendedValues="true", both registers produce identical output, enabling accurate comparison and eliminating false change detection.

Important notes

  • This setting is not applicable for reference attributes or associations

  • This setting only affects attributes configured with DuplicateAttribute="{geicl:notderivable}append". Other attribute configurations are not impacted.

  • Sorting is alphabetical (lexicographic ascending order).

Migration considerations

If enabling sortAppendedValues on an existing system:

  • Existing attribute values in the database will retain their original (unsorted) order.

  • After enabling, new updates will produce sorted values.

  • This may initially cause change records in EDW_Functional_Attribute_History as the system transitions from unsorted to sorted values.

Related configuration

Configuration

Description

DuplicateAttribute="{geicl:notderivable} append"

Appends multiple values for the same attribute using a delimiter. Works in

conjunction with sortAppendedValues.

In This Topic