Piping Stress Analysis Insulation Density - 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 Stress Analysis Insulation Density
Description: Insulation density per part, for export to stress analysis
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: InsulationDensity

SQL Query:
SELECT
CASE
WHEN jim_FEAT.Density IS NULL THEN jim_RUN.Density
ELSE jim_FEAT.Density
END InsulationDensity
FROM JRtePathGenPart jpgp
JOIN XOwnsParts rop on rop.oiddestination = jpgp.oid
JOIN XPathGeneratedParts rpgp on rpgp.oiddestination = jpgp.oid
JOIN JRteInsulation jri_FEAT on jri_FEAT.oid = rpgp.oidorigin
JOIN JInsulationMaterial jim_FEAT on jim_FEAT.MaterialType = jri_FEAT.InsulationMaterial
JOIN JRteInsulation jri_RUN on jri_RUN.oid = rop.oidorigin
JOIN JInsulationMaterial jim_RUN on jim_RUN.MaterialType = jri_RUN.InsulationMaterial
WHERE jpgp.oid = ?