Piping Pipe Run Thickness - 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: Piping Pipe Run Thickness
Description:
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: WallThickness

SQL Query:
SELECT pp.WallThicknessOrGrooveSetback AS WallThickness
FROM XMadeFrom rmf
LEFT JOIN XPartContainsNozzles rpcn on rpcn.oidorigin = rmf.oiddestination
LEFT JOIN JCatalogPipePort pp on pp.oid = rpcn.oiddestination
WHERE pp.TerminationClass = 10 and pp.PortIndex=2 and rmf.oidorigin=?