Piping Icarus Closest Parent Area in System Hierarchy - 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: Piping Icarus Closest Parent Area in System Hierarchy
Description: Format for Name of closest parent area in system Hierarchy
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
SELECT
'AreaName' =
CASE
WHEN bbb.AreaName Is NULL THEN aaa.ItemName
ELSE bbb.AreaName
END
FROM
(SELECT pli.ItemName FROM JConfigProjectRoot cpr
JOIN JNamedItem pli ON pli.oid=cpr.oid) as aaa
LEFT JOIN (SELECT TOP 1 right(pni.ItemName,24) as 'AreaName'
FROM dbo.REPORTGetAllParentsInHierarchy (? , 'SystemHierarchy') aph
JOIN JAreaSystem ars on ars.oid = aph.oidParent
JOIN JNamedItem pni on pni.oid = aph.oidparent
ORDER BY aph.depth) as bbb ON 1=1
SELECT CASE
WHEN bbb.AreaName Is NULL THEN aaa.ItemName
ELSE bbb.AreaName
END AreaName
FROM ( SELECT pli.ItemName
FROM JConfigProjectRoot cpr
JOIN JNamedItem pli ON pli.oid=cpr.oid ) aaa
LEFT JOIN ( SELECT SUBSTR(pni.ItemName,-24) as AreaName
FROM TABLE(RPTAllParentsInHierarchy (? , 'SystemHierarchy')) aph
JOIN JAreaSystem ars on ars.oid = aph.oidParent
JOIN JNamedItem pni on pni.oid = aph.oidparent
WHERE rownum = 1
ORDER BY aph.depth) bbb ON 1=1