Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

---

TREEMANAGER.findnode

Gets a list of nodes from a tree.

Syntax

<TREEMANAGER>
      <ARGUMENT NAME="ftcmd" VALUE="findnode"/>
      <ARGUMENT NAME="treename" VALUE="name"/>
      [<ARGUMENT NAME="where" VALUE="otype|oid|overison"/>]
      [<ARGUMENT NAME="column name" value="value"/>] 
      [<ARGUMENT NAME="orderby" VALUE="some order"/>]
</TREEMANAGER>

Parameters

ftcmd (required)

Value must be set to findnode.

treename (required)

Name of the tree.

where (optional)

Values of the column names containing data to use in constructing the query. Only variables whose column names appear in this list are used in constructing the query, and only columns referring to objects are allowed.

Legal values are: otype, oid, and oversion.

For example, where=otype to use the values in the variables otype to build the query.

orderby (optional)

Specifies the tree column in which to sort results.

Wildcards are not allowed in any of the variables being searched for. If a % is found in a variable whose column is specified as part of the search, it is ignored.

The name of the list that is constructed is stored in the value of the variable, treename (that is, Variables.treename).

Description

The findnode command gets a list of nodes from a tree. This is meant to perform a fast lookup of nodes referring to specific objects.

errno

The possible values of errno include:

Value	Description
-3	No access privileges to table.
-103	No table.
-110	Invalid tree name.
-111	No nodes.

Example

<TREEMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="findnode" />
   <ARGUMENT NAME="treename" VALUE="TreetestTree" />
   <ARGUMENT NAME="where" VALUE="otype" />
   <ARGUMENT NAME="otype" VALUE="TreetestObjects" />
   <ARGUMENT NAME="orderby" VALUE="nrank"/>
</TREEMANAGER>   
<IF COND="IsError.Variables.errno=false">
   <THEN>
      <LOOP LIST="Variables.treename">
         <BR/><CSVAR NAME="Variables.treename.nid"/>
      </LOOP>
   </THEN>
   <ELSE>
      <BR/> No nodes<BR/>
   </ELSE>
</IF>

See Also

getchildren

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2016, Oracle and/or its affiliates. All rights reserved.