Gets the current row number.

Syntax

Smartsite SXML	Copy Code
integer this.rownumber() integer this.rownumber(integer parentLevel)

Parameters

Name	Data Type	Description
parentLevel	Integer	The parent level. 1 is the current row's parent, 2 is the parent's parent, etc.

Return Value

Data Type	Description
Integer	Row number.

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

Examples

Format Example

This example shows you how the rowcount, visiblerowcount and other vipers can be used inside formatting.

Smartsite SXML	Copy Code
<se:xmldatatable save="games" resulttype="datatable"> <se:row><se:col name="name">Aztec Challenge</se:col></se:row> <se:row><se:col>Boulderdash</se:col></se:row> <se:row><se:col>California Games</se:col></se:row> <se:row><se:col>Defender of the Crown</se:col></se:row> <se:row><se:col>Enduro Racer</se:col></se:row> <se:row><se:col>Frogger</se:col></se:row> <se:row><se:col>Giana Sisters</se:col></se:row> <se:row><se:col>Henry's House</se:col></se:row> <se:row><se:col>International Karate</se:col></se:row> <se:row><se:col>James Bond</se:col></se:row> <se:row><se:col>Kik-Start</se:col></se:row> <se:row><se:col>Le Mans</se:col></se:row> <se:row><se:col>Microprose Soccer</se:col></se:row> <se:row><se:col>Nautilus</se:col></se:row> <se:row><se:col>Outrun</se:col></se:row> <se:row><se:col>Paperboy</se:col></se:row> <se:row><se:col>Q-Bert</se:col></se:row> <se:row><se:col>Road Runner</se:col></se:row> <se:row><se:col>Summer Games</se:col></se:row> <se:row><se:col>Test Drive</se:col></se:row> <se:row><se:col>Ultra-Smash</se:col></se:row> <se:row><se:col>Vegas Jackpot</se:col></se:row> <se:row><se:col>Where In The World Is Carmen Sandiego</se:col></se:row> <se:row><se:col>Xyron</se:col></se:row> <se:row><se:col>Yathzee</se:col></se:row> <se:row><se:col>Zak Mckracken And The Alien Mindbenders</se:col></se:row> </se:xmldatatable> <se:format inputdata="games" skiprows="6" maxrows="14"> <se:rowformat trim="right" match="odd"> {this.visiblerownumber()}. {this.field(name)} (rownr={sys.eval(this.rownumber() + this.skiprows())})<br /> </se:rowformat> <se:resultformat> {this.result()} <hr /> Displayed {this.visiblerowcount()} rows of {this.rowcount()} in total. </se:resultformat> </se:format>

Smartsite SXML

Copy Code

<se:xmldatatable save="games" resulttype="datatable">
    <se:row><se:col name="name">Aztec Challenge</se:col></se:row>
    <se:row><se:col>Boulderdash</se:col></se:row>
    <se:row><se:col>California Games</se:col></se:row>
    <se:row><se:col>Defender of the Crown</se:col></se:row>
    <se:row><se:col>Enduro Racer</se:col></se:row>
    <se:row><se:col>Frogger</se:col></se:row>
    <se:row><se:col>Giana Sisters</se:col></se:row>
    <se:row><se:col>Henry's House</se:col></se:row>
    <se:row><se:col>International Karate</se:col></se:row>
    <se:row><se:col>James Bond</se:col></se:row>
    <se:row><se:col>Kik-Start</se:col></se:row>
    <se:row><se:col>Le Mans</se:col></se:row>
    <se:row><se:col>Microprose Soccer</se:col></se:row>
    <se:row><se:col>Nautilus</se:col></se:row>
    <se:row><se:col>Outrun</se:col></se:row>
    <se:row><se:col>Paperboy</se:col></se:row>
    <se:row><se:col>Q-Bert</se:col></se:row>
    <se:row><se:col>Road Runner</se:col></se:row>
    <se:row><se:col>Summer Games</se:col></se:row>
    <se:row><se:col>Test Drive</se:col></se:row>
    <se:row><se:col>Ultra-Smash</se:col></se:row>
    <se:row><se:col>Vegas Jackpot</se:col></se:row>
    <se:row><se:col>Where In The World Is Carmen Sandiego</se:col></se:row>
    <se:row><se:col>Xyron</se:col></se:row>
    <se:row><se:col>Yathzee</se:col></se:row>
    <se:row><se:col>Zak Mckracken And The Alien Mindbenders</se:col></se:row>
</se:xmldatatable>

<se:format inputdata="games" skiprows="6" maxrows="14">
    <se:rowformat trim="right" match="odd">
        {this.visiblerownumber()}. {this.field(name)} (rownr={sys.eval(this.rownumber() + this.skiprows())})<br />
    </se:rowformat>
    
    <se:resultformat>
        {this.result()}
        <hr />
        Displayed {this.visiblerowcount()} rows of {this.rowcount()} in total.
    </se:resultformat>
</se:format>

This Length Example

This example shows the usage of this.length() and this.rownumber() within an se:placeholder macro.

Smartsite SXML	Copy Code
<se:placeholder id="test" whitespace="remove"> <se:parameters> <se:parameter name="fieldnames">key,value</se:parameter> <se:parameter name="rowformat"> <tr><td>{this.field(value)} ({this.rownumber()}/{this.length()})</td></tr> </se:parameter> <se:parameter name="resultformat"> <table>{this.result()}</table> </se:parameter> <se:parameter name="rowdelimiter">{char.crlf()}</se:parameter> <se:parameter name="sortcolumn">key</se:parameter> </se:parameters> </se:placeholder> {page.test.add(2, 'Second result')} {page.test.add(5, 'Fith result')} {page.test.add(1, 'First result')} {page.test.add(3, 'Third result')} {page.test.add(4, 'Fourth result')}

Smartsite SXML

Copy Code

<se:placeholder id="test" whitespace="remove">
    <se:parameters>
        <se:parameter name="fieldnames">key,value</se:parameter>        
        <se:parameter name="rowformat">
            <tr><td>{this.field(value)} ({this.rownumber()}/{this.length()})</td></tr>
        </se:parameter>
        <se:parameter name="resultformat">
            <table>{this.result()}</table>
        </se:parameter>
        <se:parameter name="rowdelimiter">{char.crlf()}</se:parameter>
        <se:parameter name="sortcolumn">key</se:parameter>        
    </se:parameters>
</se:placeholder>

{page.test.add(2, 'Second result')}
{page.test.add(5, 'Fith result')}
{page.test.add(1, 'First result')}
{page.test.add(3, 'Third result')}
{page.test.add(4, 'Fourth result')}

SXML