Parent and Child Functions

Question 1

PATH(ID_columnName, parent_columnName)

Answer 1

Returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing until current.

Question 2

PATHITEMREVERSE(path, position[, type])

Answer 2

Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from right to left.

Question 3

PATHITEM(path, position[, type])

Answer 3

Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left to right.

Question 4

PATHLENGTH(path)

Answer 4

Returns the number of parents to the specified item in a given PATH result, including self.

Question 5

PATHCONTAINS(path, item)

Answer 5

Returns TRUE if the specified item exists within the specified path.