Home > Contents > 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
, andoversion
.
- For example,
where
=otype
to use the values in the variablesotype
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
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.