rsSortTree

Sorts a ResultSet that is a representation of an XML data structure (with nodes, parent nodes, and depth attributes).

Type and Usage

Parameters

Takes seven parameters. For example:

rsSortTree(rsName,itemIdCol,parentIdCol,nestLevelCol,sortCol,sortType,sortOrder)
Parameter Description
rsName The name of the ResultSet.
itemIdCol The name of the column that contains the unique ID for each node.
parentIdCol The name of the column that contains the ID for the parent node, if one exists.
nestLevelCol The name of the column that contains the nest level (depth) for each node.
sortCol The name of the column to sort by.
sortType The type of sort (defaults to int):

string: sort alphabetically

int: sort numerically

date: sort by date
sortOrder The sort order (defaults to asc):

asc: ascending order

desc: descending order

Output

  • Returns TRUE if the function is successful.

  • Returns FALSE if the function fails or the ResultSet is empty.

Example

Sorts the discussionPosts ResultSet by the itemNumber column in ascending order:

<$rsSortTree("discussionPosts", "discussionPosts!itemNumber", "discussionPosts!parentNumber", "dpItemNestLevel", "discussionPosts!itemNumber", "int", "asc")$>