Gets the raw field value of the current column in the current row, when using colformat.

Syntax

Smartsite SXML	Copy Code
any this.rawfield() any this.rawfield(integer index) any this.rawfield(string fieldName)

Parameters

Name	Data Type	Description
index	Integer	The 1-based index of the field.
fieldName	String	Name of the field.

Return Value

Data Type	Description
Any	Field value.

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

This Rawfield Example

When using the sqlquery macro to display a number of items, and (one of) the fields you want to display contains vipers which should be executed, you would need to use the this.rawfield() viper enclosed within a sxml.execute() viper.

The this.rawfield() viper returns the exact string from the database, whereas the this.field viper will encode the returned string (if it's a string field) to disable both viper and module processing.

Smartsite SXML	Copy Code
<se:region error="Invalid request"> {buffer.set(dt, request.query('m', default='200901'))} {buffer.set(dtfrom, datetime.setdate(datetime.now(), string.substring($dt, 0, 4), string.substring($dt, 4, 2), 1))} {buffer.set(dtto, sys.iif(request.query.exists(m), datetime.addmonths($dtfrom, 1), datetime.addyears($dtfrom, 100)))} <se:sqlquery error="{this.error.message()}"> <se:parameters> <se:parameter name="sql"> SELECT TOP 10 c.Nr, c.Title, c.Body, c.Author, c.AddDate, c.Code FROM {channel.view()} c JOIN Contenttypes ct ON c.Contenttype=ct.Nr WHERE ct.Code = 'NWS' AND (adddate BETWEEN ?:fromdate AND ?:todate) ORDER by c.AddDate DESC </se:parameter> <se:parameter name="params"> <se:collection> <se:member name="fromdate" type="datetime">{buffer.get(dtfrom)}</se:member> <se:member name="todate" type="datetime">{buffer.get(dtto)}</se:member> </se:collection> </se:parameter> <se:parameter name="format"> <se:rowformat expression="cms.ischildof(this.field(nr),translation.arg(2, default=itemdata.number()))"> <div class="news"> <div class="newsheader"> <div class="newstitle"> <a href="{channel.link(this.field(nr))}"><h2><span>{this.field(title)}</span></h2></a> </div> </div> <div class="newsbody"> <div class="newstext"> {sxml.execute(this.rawfield(body))} </div> </div> </div> </se:rowformat> </se:parameter> <se:parameter name="resultformat"> {this.result()} </se:parameter> <se:parameter name="default"> <p>No news items.</p> </se:parameter> </se:parameters> </se:sqlquery> </se:region>

Smartsite SXML

Copy Code

<se:region error="Invalid request">
    {buffer.set(dt, request.query('m', default='200901'))}
    {buffer.set(dtfrom, datetime.setdate(datetime.now(), string.substring($dt, 0, 4), string.substring($dt, 4, 2), 1))}
    {buffer.set(dtto, sys.iif(request.query.exists(m), datetime.addmonths($dtfrom, 1), datetime.addyears($dtfrom, 100)))}

    <se:sqlquery error="{this.error.message()}">
        <se:parameters>
            <se:parameter name="sql">
                SELECT TOP 10 c.Nr, c.Title, c.Body, c.Author, c.AddDate, c.Code
                FROM {channel.view()} c
                JOIN Contenttypes ct ON c.Contenttype=ct.Nr
                WHERE ct.Code = 'NWS'
                AND (adddate BETWEEN ?:fromdate AND ?:todate)
                ORDER by c.AddDate DESC                
            </se:parameter>        
            <se:parameter name="params">
                <se:collection>
                    <se:member name="fromdate" type="datetime">{buffer.get(dtfrom)}</se:member>
                    <se:member name="todate" type="datetime">{buffer.get(dtto)}</se:member>
                </se:collection>
            </se:parameter>
            <se:parameter name="format">
                <se:rowformat expression="cms.ischildof(this.field(nr),translation.arg(2, default=itemdata.number()))">
                    <div class="news">
                        <div class="newsheader">
                            <div class="newstitle">
                                <a href="{channel.link(this.field(nr))}"><h2><span>{this.field(title)}</span></h2></a>
                            </div>                        
                        </div>
                        <div class="newsbody">
                            <div class="newstext">
                                {sxml.execute(this.rawfield(body))}
                            </div>
                        </div>
                    </div>                
                </se:rowformat>
            </se:parameter>
            <se:parameter name="resultformat">
                {this.result()}
            </se:parameter> 
            <se:parameter name="default">
                        <p>No news items.</p>
            </se:parameter>
        </se:parameters>
    </se:sqlquery>
</se:region>

SXML