Gaskets 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: Gaskets
Description: Material Description Label for Gaskets
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 JG.GasketType_ShortValue,
JEC.PressureRating_LongValue,
JG.ThicknessFor3DModel,
JG.Manufacturer_ShortValue, JG.StyleNumber_ShortValue, JG.GasketIndustryStandard_ShortValue as GsktIndStandard_ShortValue,
JG.MaterialsGrade_ShortValue,
JG.FlangeFacing_ShortValue from dbo.JGasket_CL JG
join JGasketselectionFilter JGSF ON (JGSF.ContractorCommoditycode = JG.IndustryCommoditycode)
join JEndConditions_CL JEC ON (JGSF.oid = JEC.oid)
join XImpliedMatingParts Imp ON (JG.oid = Imp.oiddestination)
where Imp.oidOrigin= ?

Select distinct ClGsktT.SHORTSTRINGVALUE as GasketType_ShortValue,
ClPR.LONGSTRINGVALUE as PressureRating_LongValue,
JG.ThicknessFor3DModel,
ClMfd.SHORTSTRINGVALUE as Manufacturer_ShortValue,
CLGSN.SHORTSTRINGVALUE as StyleNumber_ShortValue,
ClGIS.SHORTSTRINGVALUE as GsktIndStandard_ShortValue,
ClMGr.SHORTSTRINGVALUE as MaterialsGrade_ShortValue,
ClFF.SHORTSTRINGVALUE as FlangeFacing_ShortValue
from CL_GasketType ClGsktT
join JGasket JG ON (ClGsktT.VALUEID = JG.GasketType)
join JGasketselectionFilter JGSF ON (JGSF.ContractorCommoditycode = JG.IndustryCommoditycode)
join JEndConditions JEC ON (JGSF.oid = JEC.oid)
join CL_PressureRating ClPR ON (ClPR.VALUEID = JEC.PressureRating)
join CL_MANUFACTURER ClMfd ON (ClMfd.VALUEID = JG.Manufacturer)
join CL_GasketStyleNumber CLGSN ON (CLGSN.VALUEID = JG.StyleNumber)
join CL_GEOMETRICINDUSTRYSTANDARD ClGIS on (ClGIS.VALUEID= JG.GasketIndustryStandard)
join CL_MATERIALSGRADE ClMGr on (ClMGr.VALUEID = JG.MaterialsGrade)
join CL_FLANGEFACING ClFF on (ClFF.VALUEID = JG.FlangeFacing)
join XImpliedMatingParts Imp ON (JG.oid = Imp.oiddestination)
where Imp.oidOrigin= ?