API17:JTableNested

This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

JTableNested is a table class which supports modified pre-order tree traversal behaviour. This class is derived from the base JTable class and adds methods to support a binary tree structure in the database, with pre-order being the preferred method of traversal.

Defined in

libraries/joomla/database/tablenested.php

Subpackage

Database

Extends

JTable

Extended by

• JTableAsset
• JTableCategory
• JTableMenu

Methods

Method name	Description
check	Asset that the nested set data is valid.
debug	Sets the debug level on or off.
delete	Method to delete a node, and optionally its child nodes, from the table.
getPath	Method to get an array of nodes from a given node to its root.
getRootId	Gets the ID of the root item in the tree.
getTree	Method to get a node and all its child nodes.
isLeaf	Method to determine if a node is a leaf node in the tree (has no children).
move	Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.
moveByReference	Method to move a node and its children to a new location in the tree.
orderDown	Method to move a node one position to the right in the same level.
orderUp	Method to move a node one position to the left in the same level.
publish	Method to set the publishing state for a node or list of nodes in the database table.
rebuild	Method to recursively rebuild the whole nested set tree.
rebuildPath	Method to rebuild the node's path field from the alias values of the nodes from the current node to the root node of the tree.
saveorder	Method to update order of table rows.
setLocation	Method to set the location of a node in the tree object.
store	Method to store a node in the database table.
_getNode	Method to get nested set properties for a node in the tree.
_getTreeRepositionData	Method to get various data necessary to make room in the tree at a location for a node and its children.
_logtable
_runQuery

Importing

jimport( 'joomla.database.tablenested' );

See also

• Other versions of this class

Examples

<CodeExamplesForm />