Gets the result of the current row.

Syntax

Smartsite SXML	Copy Code
string this.rowresult()

Parameters

This Viper method does not expose any parameters.

Return Value

Data Type	Description
String	Row result.

Used in

Macro	Description
Calendar	Smartsite Web Toolkit Calendar module.
CmsItemData	Library methods for retrieving the current Cms item's properties.
Dir	Returns the directory listing of a specified path.
FeedReader	FeedReader macro. Reads RSS from the given location and converts it into a hierarchical SXML DataTable for formatting.
Filter	Filters and sorts records from the InputData reader.
FilterByHierarchy	Filters content by using the Cms hierarchy.
Format	Formats the given datatable.
ImageProperties	Displays the image properties of one or more images.
ItemComments	View and modify item comments.
ItemData	Library methods for retrieving the current Cms item's properties.
Join	Joins two DataTables into one.
Lorem	Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
Metadata	Provides metadata that can be included in an HTML page and forwarded to external components such as the PDF generator and Image Processor.
Parents	Shows links to parent pages.
PlaceHolder	Represents a datatable that can be accessed from other elements while in scope, then formatted and rendered when going out of scope.
Poll	Smartsite Web Toolkit Polling Module
RSS	Creates an RSS feed based on the items under the given parent.
Siblings	Siblings module allows navigating through a data set by displaying links to first, previous, next and last records.
SiteMap	Displays the site hierarchy inside a specified folder.
SmartletEditor	Edits a Smartlet.
SmiData	Macro that can be used to retrieve report data from SMI. This macro returns a DataTable with the requested information.
Sort	Sorts the output of the given data.
SqlQuery	Executes sql queries/statements and shows the results.
Statistics	The Statistics class can be used to retrieve page request information for the given items and displays it.
Tags	Renders server/user Tags.
ViewHierarchy	Displays a hierarchy based on a data table.
Webservice	Macro to execute a webservice request and embed the result in a page. Note that this macro will by default return an XmlReader object as result.
XLinks	Shows links to other pages in the site.
XmlDataTable	Module that creates a DataTable from an xml document

Example

XmlDataTable and Format Example

This example demonstrates the use of XmlDataTable to fill a datatable and the Format macro to render a datatable.

Note that the format macro is a special case where you can use formatting and the resultformat parameter inside the macro itself. This is a convenient way of formatting a datatable after you have modified it using other macros such as Join or Sort.

Smartsite SXML	Copy Code
<se:xmldatatable save="inputdatatable" resulttype="datatable"> <se:row> <se:col name="Animal">Tiger</se:col> <se:col name="Legs" datatype="integer">4</se:col> <se:col name="Diet">carnivore</se:col> </se:row> <se:row> <se:col>Owl</se:col> <se:col>2</se:col> <se:col>carnivore</se:col> </se:row> <se:row> <se:col>Snake</se:col> <se:col>0</se:col> <se:col>carnivore</se:col> </se:row> <se:row> <se:col>Rabbit</se:col> <se:col>4</se:col> <se:col>herbivore</se:col> </se:row> <se:row> <se:col>Bee</se:col> <se:col>6</se:col> <se:col>herbivore</se:col> </se:row> <se:row> <se:col>Human</se:col> <se:col>2</se:col> <se:col>omnivore</se:col> </se:row> <se:row> <se:col>Bear</se:col> <se:col>4</se:col> <se:col>omnivore</se:col> </se:row> </se:xmldatatable> <se:format inputdata="inputdatatable" rem="render datatable in an html table"> <se:rowformat> <se:colformat><td>{this.field()}</td></se:colformat> <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult> </se:rowformat> <se:captionformat match="first"> <se:colformat><th>{this.colname()}</th></se:colformat> <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult> </se:captionformat> <se:resultformat><table>{char.crlf()}{this.result()}</table></se:resultformat> </se:format>

Smartsite SXML

Copy Code

<se:xmldatatable save="inputdatatable" resulttype="datatable">
    <se:row>
        <se:col name="Animal">Tiger</se:col>
        <se:col name="Legs" datatype="integer">4</se:col>
        <se:col name="Diet">carnivore</se:col>
    </se:row>
    <se:row>
        <se:col>Owl</se:col>
        <se:col>2</se:col>
        <se:col>carnivore</se:col>
    </se:row>
    <se:row>
        <se:col>Snake</se:col>
        <se:col>0</se:col>
        <se:col>carnivore</se:col>
    </se:row>
    <se:row>
        <se:col>Rabbit</se:col>
        <se:col>4</se:col>
        <se:col>herbivore</se:col>
    </se:row>
    <se:row>
        <se:col>Bee</se:col>
        <se:col>6</se:col>
        <se:col>herbivore</se:col>
    </se:row>
    <se:row>
        <se:col>Human</se:col>
        <se:col>2</se:col>
        <se:col>omnivore</se:col>
    </se:row>
    <se:row>
        <se:col>Bear</se:col>
        <se:col>4</se:col>
        <se:col>omnivore</se:col>
    </se:row>
</se:xmldatatable>

<se:format inputdata="inputdatatable" rem="render datatable in an html table">
    <se:rowformat>
        <se:colformat><td>{this.field()}</td></se:colformat>
        <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult>
    </se:rowformat>

    <se:captionformat match="first">
        <se:colformat><th>{this.colname()}</th></se:colformat>
        <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult>
    </se:captionformat>

    <se:resultformat><table>{char.crlf()}{this.result()}</table></se:resultformat>
</se:format>

SXML