Lianja

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>

Lianja

llSuccess = .F.

loXml = createobject("CkXml")

// The sample input XML is available at http://www.chilkatsoft.com/data/fruitSort2.xml
llSuccess = loXml.LoadXmlFile("fruitSort2.xml")
if (llSuccess <> .T.) then
    ? loXml.LastErrorText
    release loXml
    return
endif

// Sort the direct children under the "fruits" node by tag:
loXSortRoot = loXml.FindChild("fruits")

// Sort in ascending order.
llBAscending = .T.
loXSortRoot.SortByContent(llBAscending)

// Show the result:
? loXml.GetXml()

// 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:
llSuccess = loXSortRoot.FindChild2("apples")

loXSortRoot.SortByContent(llBAscending)
? loXml.GetXml()

// <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>

release loXSortRoot


release loXml