Displays a hierarchy based on a data table.

Syntax

Smartsite SXML	Copy Code
<se:viewhierarchy> <se:parameters> <se:parameter name="keyfield"> </se:parameter> <se:parameter name="parentfield"> </se:parameter> <se:parameter name="inputdata"> </se:parameter> </se:parameters> </se:viewhierarchy>

Smartsite SXML

Copy Code

<se:viewhierarchy>
    <se:parameters>
        <se:parameter name="keyfield">
            
        </se:parameter>
        <se:parameter name="parentfield">
            
        </se:parameter>
        <se:parameter name="inputdata">
            
        </se:parameter>
    </se:parameters>
</se:viewhierarchy>

Parameters

Name	Data Type	Properties	Description
ChildOrderField	String	-	Sets or returns the name of the field that determines the sort order of a node's children.
Format	String	RawData	Sets the formatting Xml.
IncludeRoot	Boolean	-	Determines if the StartItem will be included in the output. Does not influence level.
InputData	DataTable	IsRequired	DataTable containing the hierarchically ordered data.
KeyField	String	IsRequired	Sets or returns the name of the key field.
LevelField	String	-	Sets or returns the name of the level field.
MaxLevels	Integer	-	Maximum number of levels that will be determined. Initialized at 2. 0 means no maximum, returning all items below the StartItem.
MaxRows	Integer	-	Sets a limit for the number of rows that the output may contain.
ParentField	String	IsRequired	Sets or returns the name of the parent field.
RecurseOnField	String	-	Sets or returns the name of the field that determines if a node can have children.
RecurseOnValue	Any	-	Sets or returns the value for the RecurseOnField for which children will be added.
RootNode	Any	-	Dete
RowDelimiter	String	-	Specifies the delimiter string that separates individual records.
RowFormat	String	RawData	Sets the formatting string.
SkipRows	Integer	-	Specifies which row will be the first row in the output.

Shared Parameters

Name	Data Type	Properties	Description
Access	String	-	Friendly name of the minimum access type level required by the site visitor to execute this macro.
AccessDenied	String	RawData	Sets the value that is returned when the site visitor has insufficient access.
AIM	Enum	-	Sets the AIM scanning mode of the macro. Enum values: NotSet Not set. Off No AIM scanning. External Output XML scanning. Internal Internal scanning, implemented by AIM-aware macros. Autonomous Relations are to be linked to the current source item, instead of the rendered page. SoftLink Should generate soft links (in combination with External flag). InternalAutonomous Internal scanning, combined with the Autonomous setting. ExternalAutonomous External scanning, combined with the Autonomous setting. ExternalAutonomousSoftLink External scanning, combined with the Autonomous and softLink settings. ExternalSoftLink External scanning, combined with the Softlink setting.
Condition	String	MustBeAttribute ExpressionSyntax XmlDecode	Sets the Viper expression to evaluate before actually executing the macro. If the expression returns false, the execution of the module and its child modules is skipped.
Default	String	RawData	Sets the default value that will be returned when the execution would otherwise return an empty string.
Error	String	RawData	Sets the value to return in case on error occurs during execution. The Viper expressions this.error(), this.error(full) and this.error(type) are available in this context.
Id	String	MustBeAttribute Trim	Sets the Id of the macro. Macros with Ids set can be accessed using Viper by referring to page.[id].[methodname()].
LocalId	String	MustBeAttribute Trim	Sets the local id of the macro in the current buffer scope.
Rem	String	RawData NoCache Trim	Sets the remarks. Remarks have no effect on the actual execution of the module. They only improve the readability of the code.
ResultFormat	String	RawData	Sets the resultformat.
ResultType	Enum	-	Sets the type of the result. Enum values: Undefined Not set None No result String Default type Object Generic object Binary Binary data Boolean Boolean DataTable DataTable DateTime Date/time Float Floating point numeric data Integer Integer Locator Extended Uri Xml Xml Data
Save	Collection	-	Sets the buffer names.
Status	Enum	-	Gets a value indicating the ModuleStatus of this module. Enum values: Unknown Unknown BeginInitialize Initializing the module EndInitialize Module has fully initialized BeginSetProperties Properties are about to be set EndSetProperties Properties have been set BeginExecute Execution starts BeginFormatData Starting data formatting. EndFormatData Ended data formatting. BeginFormatResult Before formating result. EndFormatResult After formatting result EndExecute Execution is ending StartLoseScope Execution has completed EndLoseScope Module is about to unload Error Module is in an error state
Timeout	Float	-	Sets the timeout in seconds. In the overriden Execute() method, you can call CheckTimeout() to check whether execution has timed out.
Trim	Enum	MustBeAttribute	Gets a value indicating how the whitespace is trimmed.
Whitespace	Enum	MustBeAttribute	Gets a value indicating whether to preserve whitespace. Enum values: Inherit Inherit from parent. Preserve Keep all whitespace. Remove Remove all whitespace. Normalize Convert all whitespace to single spaces. SimpleFormat Convert all whitespace to single spaces, but keep single line breaks.

Local Viper Methods

Viper	Extension	Description
This.ChildLevelResult		Gets the result of the child levels.
This.ClearForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.
This.ColCount		Gets the number of columns in the datatable.
This.ColName		Gets the name of the current column.
This.ColNumber		Gets the number of the current column.
This.Field		Gets the field value of the current column in the current row, when using colformat.
This.Field.Exists		Checks whether the given field exists.
This.GetForcedResult		Gets the forced result of the macro, set by overriding the normal rendering using SetForcedResult().
This.Group		Gets the name of the current group.
This.GroupCount		Gets the total number of groups displayed.
This.GroupNumber		Gets the number of the current group.
This.GroupResult		Gets the result of the current group.
This.GroupRowNumber		Gets the number of the current row in the current group.
This.Level		Gets the current formatting level.
This.LevelResult		Gets the result of the current level.
This.LevelRowNumber		Gets the current row of the current level.
This.Location		Gets the location the current row points to, in a macro that can build URLs.
This.MaxRows		Gets a limit for the number of rows that the output may contain.
This.Name		Gets the title or name represented by the current row.
This.param		Gets the value of a parameter with the given index. Useful when using the viper:exec inside xslt formatting.
This.RawField		Gets the raw field value of the current column in the current row, when using colformat.
This.RenderTime	✓	Returns the render time of the macro in milliseconds.
This.RowCount		Gets the total number of rows in the datatable.
This.RowNumber		Gets the current row number.
This.RowResult		Gets the result of the current row.
This.SetForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.
This.SkipRows		Specifies which row will be the first row in the output.
This.Title		Gets the title represented by the current row.
This.VisibleRowCount		Gets the total number of rows displayed.
This.VisibleRowNumber		Gets the current visible row number.

Shared Local Viper Methods

Viper	Extension	Description
This.AIM.Relations	✓	Gets a list of all outgoing AIM relations created by the macro.
This.Buffer.Exists		Checks whether a local buffer exists.
This.Buffer.Get		Gets a local buffer.
This.Buffer.Set		Sets a local buffer.
This.Error.InnerException.Message		Returns the text message of the inner exception of the exception that has occurred.
This.Error.InnerException.SmartsiteCode		Returns Smartsite error code of the inner exception of the exception that has occurred.
This.Error.InnerException.Throw		Makes Smartsite throw the inner exception.
This.Error.InnerException.ToString		Returns the full information of the inner exception of the exception that has occurred, including the stack trace.
This.Error.InnerException.Type		Returns the full Type name of the inner exception of the exception that has occurred.
This.Error.Message		Returns the text message of the exception that has occurred.
This.Error.SmartsiteCode		Returns the Smartsite Error code of the exception that has occurred.
This.Error.Throw		Makes Smartsite throw the current exception.
This.Error.ToString		Returns the full information of the exception that has occurred, including the stack trace.
This.Error.Type		Returns the full Type name of the exception that has occurred.
This.FindExtension		Finds an extension macro.
This.GetParameter	✓	Gets the value of the given parameter/property.
This.ParameterExists	✓	Checks whether the given parameter/property is set.
This.Result		Returns the result of the macro. Typically used in the ResultFormat property, to format, convert or encode the result.
This.SXMLPath		Gets the path to the macro in the current execution stack.

Remarks

Examples

ViewHierarchy from XmlDataTable Example

In this example the parent-child relation used by ViewHierarchy is based on the relation between parent and key fields. Nesting is made visible by indenting the children of each row.

Smartsite SXML	Copy Code
<se:xmldatatable> <se:parameters> <se:parameter name="resulttype">datatable</se:parameter> <se:parameter name="save">data</se:parameter> <se:parameter name="xml"> <se:row> <se:col name="key" datatype="string">root</se:col> </se:row> <se:row> <se:col>Science</se:col> <se:col name="parent" datatype="string">root</se:col> </se:row> <se:row> <se:col>Music</se:col> <se:col>root</se:col> </se:row> <se:row> <se:col>Physics</se:col> <se:col>Science</se:col> </se:row> <se:row> <se:col>Chemistry</se:col> <se:col>Science</se:col> </se:row> <se:row> <se:col>Astrophysics</se:col> <se:col>Physics</se:col> </se:row> <se:row> <se:col>Quantum Chromo Dynamics</se:col> <se:col>Physics</se:col> </se:row> <se:row> <se:col>Metal</se:col> <se:col>Music</se:col> </se:row> <se:row> <se:col>Rock</se:col> <se:col>Music</se:col> </se:row> <se:row> <se:col>Jazz</se:col> <se:col>Music</se:col> </se:row> </se:parameter> </se:parameters> </se:xmldatatable> <se:viewhierarchy> <se:parameters> <se:parameter name="inputdata">data</se:parameter> <se:parameter name="keyfield">key</se:parameter> <se:parameter name="parentfield">parent</se:parameter> <se:parameter name="format"> <se:rowformat>{string.repeat(char.tab(), this.field(level))}{this.field(key)}</se:rowformat> <se:rowdelimiter>{char.crlf()}</se:rowdelimiter> </se:parameter> </se:parameters> </se:viewhierarchy>

Smartsite SXML

Copy Code

<se:xmldatatable>
    <se:parameters>
        <se:parameter name="resulttype">datatable</se:parameter>
        <se:parameter name="save">data</se:parameter>
        <se:parameter name="xml">
            <se:row>
                <se:col name="key" datatype="string">root</se:col>
            </se:row>
            <se:row>
                <se:col>Science</se:col>
                <se:col name="parent" datatype="string">root</se:col>
            </se:row>
            <se:row>
                <se:col>Music</se:col>
                <se:col>root</se:col>
            </se:row>
            <se:row>
                <se:col>Physics</se:col>
                <se:col>Science</se:col>
            </se:row>
            <se:row>
                <se:col>Chemistry</se:col>
                <se:col>Science</se:col>
            </se:row>
            <se:row>
                <se:col>Astrophysics</se:col>
                <se:col>Physics</se:col>
            </se:row>
            <se:row>
                <se:col>Quantum Chromo Dynamics</se:col>
                <se:col>Physics</se:col>
            </se:row>
            <se:row>
                <se:col>Metal</se:col>
                <se:col>Music</se:col>
            </se:row>
            <se:row>
                <se:col>Rock</se:col>
                <se:col>Music</se:col>
            </se:row>
            <se:row>
                <se:col>Jazz</se:col>
                <se:col>Music</se:col>
            </se:row>
        </se:parameter>
    </se:parameters>
</se:xmldatatable>
<se:viewhierarchy>
    <se:parameters>
        <se:parameter name="inputdata">data</se:parameter>
        <se:parameter name="keyfield">key</se:parameter>
        <se:parameter name="parentfield">parent</se:parameter>
        <se:parameter name="format">
            <se:rowformat>{string.repeat(char.tab(), this.field(level))}{this.field(key)}</se:rowformat>
            <se:rowdelimiter>{char.crlf()}</se:rowdelimiter>
        </se:parameter>
    </se:parameters>
</se:viewhierarchy>

Build your own Sitemap routine

Instead of using the sitemap macro, you can use SXML to get more granular control over what it does internally.

For this to work, simply generate a datatable using an sqlquery macro, and format the datatable using viewhierarchy.

Smartsite SXML	Copy Code
<se:viewhierarchy keyfield="nr" parentfield="parent" childorderfield="listorder" rootnode="24665"> <se:parameters> <se:parameter name="inputdata"> <se:sqlquery resulttype="datatable"> <se:parameters> <se:parameter name="sql"> select nr, parent, title, listorder, sortindex, adddate from {channel.view()} </se:parameter> </se:parameters> </se:sqlquery> </se:parameter> <se:parameter name="format"> <se:rowformat> <li> <a href="{channel.link(this.field(nr))}">{this.field(title)}</a> {this.childlevelresult()} </li> </se:rowformat> <se:levelformat groupby="this.field(level)"> <ul>{this.levelresult()}</ul> </se:levelformat> </se:parameter> <se:parameter name="resultformat"> <ul> {this.result()} </ul> </se:parameter> </se:parameters> </se:viewhierarchy>

Smartsite SXML

Copy Code

<se:viewhierarchy keyfield="nr" parentfield="parent" childorderfield="listorder" rootnode="24665">
    <se:parameters>
        <se:parameter name="inputdata">
            <se:sqlquery resulttype="datatable">
                <se:parameters>
                    <se:parameter name="sql">
                        select nr, parent, title, listorder, sortindex, adddate 
                        from {channel.view()}
                    </se:parameter>
                </se:parameters>
            </se:sqlquery>
        </se:parameter>
        <se:parameter name="format">
            <se:rowformat>
                <li>
                    <a href="{channel.link(this.field(nr))}">{this.field(title)}</a>
                    {this.childlevelresult()}
                </li>
            </se:rowformat>
            <se:levelformat groupby="this.field(level)">
                <ul>{this.levelresult()}</ul>
            </se:levelformat>
        </se:parameter>
        <se:parameter name="resultformat">
            <ul>
                {this.result()}
            </ul>
        </se:parameter>
    </se:parameters>
</se:viewhierarchy>

SXML