Profile Cross-section Material Type Grade - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

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

Name: Profile Cross-section Material Type Grade
Description:
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
set @oid = ?

select
coalesce
(
mat_1.MaterialType + ' ; ' + mat_1.MaterialGrade,
mat_2.MaterialType + ' ; ' + mat_2.MaterialGrade,
mat_3.MaterialType + ' ; ' + mat_3.MaterialGrade,
'none'
) as Material,
coalesce (pd_1.SectionName,
pd_2.SectionName, pd_3.SectionName) as SectionType
from JProfile as p
left join XShpStrDesignHierarchy as ssdh_1
on ssdh_1.oidDestination = p.oid
left join XShpStrDesignHierarchy as ssdh_2
on ssdh_2.oidDestination = ssdh_1.oidOrigin
left join XGeometryToProfile as phae_1
on phae_1.oidDestination = p.oid
left join XProfileSystemSection as phd_1
on phd_1.oidOrigin = phae_1.oidOrigin
left join JStructCrosssection as pd_1
on pd_1.Oid = phd_1.OidDestination

left join XGeometryToProfile as phae_2
on phae_2.oidDestination = ssdh_1.oidOrigin
left join XProfileSystemSection as phd_2
on phd_2.oidOrigin = phae_2.oidOrigin
left join JStructCrosssection as pd_2
on pd_2.Oid = phd_2.OidDestination

left join XGeometryToProfile as phae_3
on phae_3.oidDestination = ssdh_2.oidOrigin
left join XProfileSystemSection as phd_3
on phd_3.OidOrigin = phae_3.oidOrigin
left join JStructCrosssection as pd_3
on pd_3.Oid = phd_3.OidDestination

left join XSystemHasMaterial hasMat_1
on hasMat_1.oidDestination = p.oid
left join JDMaterial mat_1
on mat_1.oid = hasMat_1.oidOrigin

left join XSystemHasMaterial hasMat_2
on hasMat_2.oidDestination = ssdh_1.oidOrigin
left join JDMaterial mat_2
on mat_2.oid = hasMat_2.oidOrigin

left join XSystemHasMaterial hasMat_3
on hasMat_3.oidDestination = ssdh_2.oidOrigin
left join JDMaterial mat_3
on mat_3.oid = hasMat_3.oidOrigin