Structure Slab Thickness - Intergraph Smart 3D - Help - Hexagon

Intergraph Smart 3D Catalog

Language
English
Product
Intergraph Smart 3D
Subproduct
Catalog
Search by Category
Help
Smart 3D Version
13

Name: Structure Slab Thickness
Description: Thickness
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: Thickness

SQL Query:
SELECT coalesce(s.Thickness, slt.Thickness) Thickness
FROM SPSSlabEntity se
LEFT JOIN XLayerComposition rlc ON rlc.oidorigin = se.oid
JOIN JUASlabLayerType s ON s.oid = rlc.oiddestination /* layer in the model */
LEFT JOIN XSlabLayerTypeReferenceRln rslt ON rslt.oidorigin=rlc.oiddestination
JOIN JUASlabLayerType slt ON slt.oid= rslt.oiddestination /* layer in the catalog */
WHERE se.oid = ?