Piping ToolTip Piping Connection - 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 ToolTip Piping Connection
Description: Example of a Label for Piping Connection
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 distinct
dc.ConnectionType ConnectionType_Index,
ct.shortstringvalue ConnectionType,
case
when dc.connectiontype > 2 then 0
else b.boltquantity
end Bolts_Quantity,
case
when dc.connectiontype > 2 then ' '
else b.shortmaterialdescription
end Bolts_Description
FROM jdistribconnection dc
JOIN cl_connectiontype ct ON ct.valueid = dc.connectiontype
LEFT JOIN ( Select xrcpo.oidorigin, rb.boltquantity, jbolt.shortmaterialdescription
FROM XRelConnectionAndPartOcc xrcpo
JOIN jpartocc p ON p.oid = xrcpo.oiddestination
JOIN XRelConnectionAndPartOcc xrcpo2 ON xrcpo2.oiddestination = p.oid
JOIN jdistribconnection dc2 ON dc2.oid = xrcpo2.oidorigin
JOIN XGeneratesConnectionItems xgci ON xgci.oidorigin = dc2.oid
JOIN jrtebolt rb ON rb.oid = xgci.oiddestination
JOIN XImpliedMatingParts ximp ON ximp.oidorigin = rb.oid
JOIN jbolt ON jbolt.oid = ximp.oiddestination
) b on b.oidorigin = dc.oid
WHERE dc.oid = ?
Timeout="0">
select distinct
dc.ConnectionType ConnectionType_Index,
ct.shortstringvalue ConnectionType,
case
when dc.connectiontype > 2 then 0
else b.boltquantity
end Bolts_Quantity,
case
when dc.connectiontype > 2 then cast(' ' as nvarchar2(255))
else b.shortmaterialdescription
end Bolts_Description
FROM jdistribconnection dc
JOIN cl_connectiontype ct ON ct.valueid = dc.connectiontype
LEFT JOIN ( Select xrcpo.oidorigin, rb.boltquantity, jbolt.shortmaterialdescription
FROM XRelConnectionAndPartOcc xrcpo
JOIN jpartocc p ON p.oid = xrcpo.oiddestination
JOIN XRelConnectionAndPartOcc xrcpo2 ON xrcpo2.oiddestination = p.oid
JOIN jdistribconnection dc2 ON dc2.oid = xrcpo2.oidorigin
JOIN XGeneratesConnectionItems xgci ON xgci.oidorigin = dc2.oid
JOIN jrtebolt rb ON rb.oid = xgci.oiddestination
JOIN XImpliedMatingParts ximp ON ximp.oidorigin = rb.oid
JOIN jbolt ON jbolt.oid = ximp.oiddestination
) b on b.oidorigin = dc.oid
WHERE dc.oid = hextoraw(?)

Name="Piping ToolTip Piping Connection"
Site="User"
Path="Piping ToolTip Piping Connection.rqp" />