DataFlex

XML Sort by Content

See more XML Examples

Demonstrates the SortByContent method.

The input XML, available at http://www.chilkatsoft.com/data/fruitSort2.xml, is this:

<root>
    <fruits>
        <apples>
            <apple>fuji</apple>
            <apple>gala</apple>
            <apple>granny smith</apple>
            <apple>honeycrisp</apple>
            <apple>mcintosh</apple>
        </apples>
        <fruit>banana</fruit>
        <fruit>blackberry</fruit>
        <fruit>blueberry</fruit>
        <fruit>orange</fruit>
        <fruit>pear</fruit>
    </fruits>
</root>

DataFlex

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoXml
    Variant vXSortRoot
    Handle hoXSortRoot
    Boolean iBAscending
    String sTemp1

    Move False To iSuccess

    Get Create (RefClass(cComChilkatXml)) To hoXml
    If (Not(IsComObjectCreated(hoXml))) Begin
        Send CreateComObject of hoXml
    End

    // The sample input XML is available at http://www.chilkatsoft.com/data/fruitSort2.xml
    Get ComLoadXmlFile Of hoXml "fruitSort2.xml" To iSuccess
    If (iSuccess <> True) Begin
        Get ComLastErrorText Of hoXml To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Sort the direct children under the "fruits" node by tag:
    Get ComFindChild Of hoXml "fruits" To vXSortRoot
    If (IsComObject(vXSortRoot)) Begin
        Get Create (RefClass(cComChilkatXml)) To hoXSortRoot
        Set pvComObject Of hoXSortRoot To vXSortRoot
    End

    // Sort in ascending order.
    Move True To iBAscending
    Send ComSortByContent To hoXSortRoot iBAscending

    // Show the result:
    Get ComGetXml Of hoXml To sTemp1
    Showln sTemp1

    // Note:  The "apples" node contains child nodes, but its 
    // text content is 0-length (empty).  Therefore, when sorting in
    // ascending order, it will be positioned before the direct
    // children containing non-empty content.

    // <root>
    //     <fruits>
    //         <apples>
    //             <apple>granny smith</apple>
    //             <apple>gala</apple>
    //             <apple>fuji</apple>
    //             <apple>mcintosh</apple>
    //             <apple>honeycrisp</apple>
    //         </apples>
    //         <fruit>banana</fruit>
    //         <fruit>blackberry</fruit>
    //         <fruit>blueberry</fruit>
    //         <fruit>orange</fruit>
    //         <fruit>pear</fruit>
    //     </fruits>
    // </root>

    // Sort the direct children under the "apples" node:
    Get ComFindChild2 Of hoXSortRoot "apples" To iSuccess

    Send ComSortByContent To hoXSortRoot iBAscending
    Get ComGetXml Of hoXml To sTemp1
    Showln sTemp1

    // <root>
    //     <fruits>
    //         <apples>
    //             <apple>fuji</apple>
    //             <apple>gala</apple>
    //             <apple>granny smith</apple>
    //             <apple>honeycrisp</apple>
    //             <apple>mcintosh</apple>
    //         </apples>
    //         <fruit>banana</fruit>
    //         <fruit>blackberry</fruit>
    //         <fruit>blueberry</fruit>
    //         <fruit>orange</fruit>
    //         <fruit>pear</fruit>
    //     </fruits>
    // </root>

    Send Destroy of hoXSortRoot


End_Procedure