IsDescendant (DMX)

Indicates whether the current node descends from the specified node.

Syntax

IsDescendant(<NodeID>)

Return Type

A Boolean type.

Remarks

IsDescendant is only used in SELECT FROM <model>.CONTENT (DMX) and SELECT FROM <model>.DIMENSION_CONTENT (DMX) queries.

Examples

The following example returns all the cases that are descendents of the node that is specified in the IsDescendant function.

SELECT * FROM [TM Decision Tree].CONTENT
WHERE IsDescendant('00000000100')