Smartsite SXML CopyCode image Copy Code
<se:xmldatatable>
    <se:parameters>
        <se:parameter name="xml">
            <se:row><se:col name="Name">Abraham</se:col><se:col name="Phone">555-1423</se:col></se:row>
            <se:row><se:col>Anna</se:col><se:col>555-7485</se:col></se:row>
            <se:row><se:col>Berta</se:col><se:col>555-6349</se:col></se:row>
            <se:row><se:col>Brutus</se:col><se:col>555-4234</se:col></se:row>
        </se:parameter>
        <se:parameter name="format">
 
            <se:groupformat groupby="string.toupper(string.substring(this.field(Name), 0, 1))">
                <h3>Names starting with an '{this.group()}'</h3>
                <ul>
                    {this.groupresult()}
                </ul>
            </se:groupformat>
 
            <se:rowformat>
                <li>
                    {this.field(Name)} : {this.field(Phone)}
                </li>
            </se:rowformat>
 
        </se:parameter>
    </se:parameters>
</se:xmldatatable>
Example Result CopyCode image Copy Code
<h3>Names starting with an 'A'</h3>
                <ul>
                    
                <li>
                    Abraham : 555-1423
                </li>
            
                <li>
                    Anna : 555-7485
                </li>
            
                </ul>
            
                <h3>Names starting with an 'B'</h3>
                <ul>
                    
                <li>
                    Berta : 555-6349
                </li>
            
                <li>
                    Brutus : 555-4234
                </li>
            
                </ul>