Pipe Stock and Nipples Label - 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: Pipe Stock and Nipples Label
Description: Material Description Label for Pipe Stock and Nipples
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 Pcom.CommodityType_LongValue, dbo.REPORTConvertNPD('in',Pcom.PriSizeNPDUnits, Pcom.PrimarySize) AS 'NPD1',
'in' AS 'NPDUnitType1',
'Piping' AS 'Category',
NULL AS 'BoltDiameter',
dbo.REPORTConvertNPD('in',Pcom.SecSizeNPDUnits, Pcom.SecondarySize) AS 'NPD2',
'in' AS 'NPDUnitType2',
'[Ports]' AS PortsInfo,
Mfd.SurfacePreparation_ShortValue, Pcom.LiningMaterial_ShortValue,
Pcom.GeometricIndustryStandard_ShortValue as GeomIndStandard_ShortValue, Pcom2.Manufacturer_ShortValue,
Pcom.MaterialsGrade_ShortValue, Mfd.ManufacturingMethod,
FtoF.FacetoFace, Psto.PurchaseLength from dbo.JDPipeComponent_CL Pcom
join dbo.JUAManufacturerData_CL Mfd ON (Pcom.Oid = Mfd.Oid)
join dbo.JDPipeComponent2_CL Pcom2 ON (Pcom.Oid = Pcom2.Oid)
Left outer join dbo.JFaceToFace FtoF ON (FtoF.Oid = Pcom.Oid)
Left outer join dbo.JDPipeStock Psto ON (Psto.Oid = Pcom.Oid)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?

Select ClPco.LONGSTRINGVALUE as CommodityType_LongValue, RPTConvertNPD('in',Pcom.PriSizeNPDUnits, Pcom.PrimarySize) AS NPD1,
'in' AS NPDUnitType1,
'Piping' AS Category,
NULL AS BoltDiameter,
RPTConvertNPD('in',Pcom.SecSizeNPDUnits, Pcom.SecondarySize) AS NPD2,
'in' AS NPDUnitType2,
'[Ports]' AS PortsInfo,
ClSPre.SHORTSTRINGVALUE as SurfacePreparation_ShortValue, ClLM.SHORTSTRINGVALUE as LiningMaterial_ShortValue,
ClGIS.SHORTSTRINGVALUE as GeomIndStandard_ShortValue, ClMfd.SHORTSTRINGVALUE As Manufacturer_ShortValue,
ClMGr.SHORTSTRINGVALUE as MaterialsGrade_ShortValue, Mfd.ManufacturingMethod,
FtoF.FacetoFace, Psto.PurchaseLength from CL_PIPINGCOMMODITYTYPE ClPco
join JDPIPECOMPONENT Pcom on (ClPco.VALUEID = Pcom.COMMODITYTYPE)
join JUAManufacturerData Mfd ON (Pcom.Oid = Mfd.Oid)
join JDPipeComponent2 Pcom2 ON (Pcom.Oid = Pcom2.Oid)
Left OUTER join CL_SURFACEPREPARATION ClSPre ON (Mfd.SurfacePreparation = ClSPre.VALUEID)
join CL_LININGMATERIAL ClLM on (ClLM.VALUEID = Pcom.LiningMaterial)
join CL_GEOMETRICINDUSTRYSTANDARD ClGIS on (ClGIS.VALUEID= pcom.GeometricIndustryStandard)
join CL_MANUFACTURER ClMfd on (ClMfd.VALUEID = Pcom2.Manufacturer)
join CL_MATERIALSGRADE ClMGr on (ClMGr.VALUEID = Pcom.MaterialsGrade)
Left outer join JFaceToFace FtoF ON (FtoF.Oid = Pcom.Oid)
Left outer join JDPipeStock Psto ON (Psto.Oid = Pcom.Oid)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?