I want "3.1.1" to come after "3.1"...

How do I correctly tdefine this data in the schema, so when I use the sortby() command I have :

2.1.1
3.1
3.1.1
3.1.2

The pattern of this data is 0-9*

Thanks a lot, I read the docs but did not really figure it out.

Babs

Use the following schema:

<xs:schema xmlns:xs=“http://www.w3.org/2001/XMLSchema” xmlns:tsd=“http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name=“string”>
<tsd:collection name=“types-string”/>
<tsd:doctype name=“types”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
<xs:element name=“string” type=“xs:string”/>
</xs:schema>

with the following data:

2.1.1
3.1.2
3.1.1
3.1

and _xql = string sortby(.)

you’ll obtain

xql:result
2.1.1
3.1
3.1.1
3.1.2
</xql:result>

as desired :slight_smile: