BUILTIN.HIERARCHY

Returns the full hierarchical path to a value. Values can be returned by id or display field.

Parameters

Parameter	Required / Optional	Description	Acceptable Parameter Values
Hierarchical field	Required	A field you can chose to display as hierarchies or child values. For more information, see Hierarchical Fields.	–
Expansion Type Note: Hierarchy level can sometimes return varying results. For more information, see SuiteQL Limitations and Exceptions.	Required	Specify the way a hierarchical field is displayed in results.	Parameter values must include single quotation marks: `'DISPLAY'` `'DISPLAY_JOINED'` `'DISPLAY_SEPARATED'` `'IDENTIFIER'` `'IDENTIFIER_SEPARATED'` `'LEVEL'` `'SELF_DISPLAY'` `'SELF_IDENTIFIER'`

Parameter

Required / Optional

Description

Acceptable Parameter Values

Hierarchical field

Required

A field you can chose to display as hierarchies or child values. For more information, see Hierarchical Fields.

–

Expansion Type

Note:

Hierarchy level can sometimes return varying results. For more information, see SuiteQL Limitations and Exceptions.

Required

Specify the way a hierarchical field is displayed in results.

Parameter values must include single quotation marks:

            BUILTIN.HIERARCHY(parent, 'IDENTIFIER_SEPARATED')

            SELECT id, parent,
 BUILTIN.HIERARCHY(parent, 'IDENTIFIER_SEPARATED')
FROM Item