(DataFlex) XML Sort by Content

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>

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-win32.pkg

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

    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