Element-Hierarchy Table
The Element-Hierarchy table connects the data model to the VIM custom visual to render the filtered context in your report. It also represents the grouping information of an element (i.e. the Descendant) with a parent or ancestor element (i.e. the Element).
_key
Unique key value representing each record in the table.
Descendant
The foreign key to the Element table which defines the current element, or the terminal element if it is contained in a hierarchy of groups.
DescendantGeometry
The foreign key to the Element-Geometry table which defines the geometry of the current/terminal element. Records with no geometry will
DescendantNode
The foreign key to the Node table which defines the Descendant element's Node.
One Descendant element may be composed of multiple nodes, in which case the Element-Hierarchy record referencing this Descendant will appear for as many times as there are nodes which compose that Descendant element.
Element
The foreign key to the Element table which defines the current parent or ancestor element, or the same value as the Descendant element if it has no parents or ancestors.
Self
When true, the Descendant and the Element are the same element.
Distance
The distance (in "hops") from the Descendant to its parent or ancestor Element.
- A distance of 0 denotes that the Descendant and the Element are the same element.
- A distance of 1 denotes that the Descendant is a direct child of the Element.
- A distance of 2 denotes that the Descendant is a grand-child of the Element.
RootDistance
The distance (in "hops") from the root level.
- Descendants with a Distance of 0 and a RootDistance of 0 are considered root-level elements.
- Descendants with a non-zero RootDistance are considered children of an Element.
BimDocument_key
The foreign key to the BimDocument table which defines the BIM document that contains the Descendant.
FilePath
The file path of the VIM file which contains the Descendant element.
Url
The URL of the VIM file which contains the Descendant element.
AccessToken
If specified, this value is supplied in the request to the VIM URL in case the URL is gated behind a special access token.
Geometry.Index
The Descendant element's geometry index in the VIM file.
Node.Index
The Descendant element's node index in the VIM file.