Smartsite SXML CopyCode image Copy Code
<se:xmldatatable save="grades" resulttype="datatable">
    <se:row>
        <se:col name="Student">John</se:col>
        <se:col name="Grade">4</se:col>
    </se:row>
    <se:row>
        <se:col>Karen</se:col>
        <se:col>7</se:col>
    </se:row>
    <se:row>
        <se:col>Marian</se:col>
        <se:col>5</se:col>
    </se:row>
    <se:row>
        <se:col>Peter</se:col>
        <se:col>9</se:col>
    </se:row>
</se:xmldatatable>

{buffer.set(passedstudents, datatable.search(grades, 'grade >= 6'))}

<se:format inputdata="passedstudents">
    <se:rowformat>
        {this.field(Student)} passed with a {this.field(grade)}
    </se:rowformat>
</se:format>
Example Result CopyCode image Copy Code
Karen passed with a 7
Peter passed with a 9
SXML