Structure ToolTip for MemberSystem Location - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

Language
English
Product
Intergraph Smart 3D
Subproduct
Catalog
Search by Category
Help
Smart 3D Version
12.1 (2019)

Name: Structure ToolTip for MemberSystem Location
Description: Format of Tooltip for MemberSystem Location
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: z2
z1
Length

SQL Query:
Select
jln.length As Length,
jln.rootpointZ As z1,
jln.endZ As z2,
jname1.itemname As SystemName
From SPSMemberSystem mems
Join Jline jln on (jln.oid = mems.oid)
Join XSystemTree xtree on (xtree.oidDestination = mems.oid)
Join JNamedItem jname1 on (jname1.oid = xtree.oidOrigin)
WHERE mems.oid = ?