Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


When writing an XML file, data can be sorted with the use of sort keys.

This offers the possibility to order easily the data that is written in the XML file with, if needed, multiple sort keys.

Prerequisites:

  • Stambia DI Designer S18.3.1 or higher
  • Stambia DI Runtime S17.4.1 or higher

 

Metadata Configuration

The first step is to open the XML Metadata to add the fields that will next be used in the Mappings to sort data.

For this simply add as many 'sortKey' Property Fields as required under the node that you want to sort.

metadata

The sort keys are applied in the order they are defined in the Metadata.

 

Mapping Configuration

The Metadata being configured, you can now simply map these fields in the Mapping to sort your data.

mapping

 

Ascending / descending order

By default, the keys specified are sorting data in the ascending order

This behavior can be changed by adding one of the following tags on the sort key.

  • SORT_ASC
  • SORT_DESC

 sortOrder

 

 

 

Articles

Suggest a new Article!