Off-line Instruments Label - 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: Off-line Instruments Label
Description: Material Description Label for Off-line Instruments
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,
Mfd.ValveManufacturer_ShortValue, Mfd.ValveModelNumber_ShortValue,
Mfd.MiscRequisitionClassification_ShortValue as MiscReqClassfn_ShortValue from dbo.JDPipeComponent_CL Pcom
Left OUTER join dbo.JUAManufacturerData_CL Mfd ON (pcom.oid = Mfd.oid)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?

select ClPco.LONGSTRINGVALUE as CommodityType_LongValue,
ClVMf.SHORTSTRINGVALUE as ValveManufacturer_ShortValue, ClVMN.SHORTSTRINGVALUE as ValveModelNumber_ShortValue,
ClMRC.SHORTSTRINGVALUE as MiscReqClassfn_ShortValue
from CL_PIPINGCOMMODITYTYPE ClPco
join JDPIPECOMPONENT Pcom on (ClPco.VALUEID = Pcom.COMMODITYTYPE)
Left OUTER join JUAManufacturerData Mfd ON (Pcom.Oid = Mfd.Oid)
Left OUTER join CL_VALVEMANUFACTURER ClVMf on (ClVMf.VALUEID = Mfd.ValveManufacturer)
Left OUTER join CL_VALVEMODELNUMBER ClVMN on (ClVMN.VALUEID = Mfd.ValveModelNumber)
Left OUTER join CL_MISCREQUISITIONCLASSIFICATI ClMRC on (Mfd.MiscRequisitionClassification = ClMRC.VALUEID)
join xmadefrom rmf ON (pcom.oid = rmf.oiddestination)
where rmf.oidorigin = ?