Washers 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: Washers Label
Description: Material Description Label for Washers
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 JWa.WasherType_ShortValue,
RteW.WasherQuantity,
Wsf.BoltDiameter,
JWa.WasherThickness,
JWa.GeometricIndustryStandard_ShortValue as GeomIndStandard_ShortValue, JGMCD.Manufacturer_ShortValue,
JWa.MaterialsGrade,
JWa.CoatingType from dbo.JWasher_CL JWa
JOIN XImpliedMatingParts Imp ON (JWa.oid = Imp.oiddestination)
JOIN dbo.JRteWasher RteW ON (RteW.Oid = Imp.oidOrigin)
JOIN JWasherSelectionFilter Wsf ON (Wsf.ContractorCommoditycode = JWa.IndustryCommoditycode)
JOIN JGenericMaterialControlData_CL JGMCD on (JGMCD.ContractorCommoditycode = JWa.IndustryCommoditycode)
where Imp.oidOrigin= ?

select ClWT.SHORTSTRINGVALUE as WasherType_ShortValue,
RteW.WasherQuantity,
Wsf.BoltDiameter,
JWa.WasherThickness,
ClGIS.SHORTSTRINGVALUE as GeomIndStandard_ShortValue,
ClMfd.SHORTSTRINGVALUE as Manufacturer_ShortValue,
ClMGr.SHORTSTRINGVALUE as MaterialsGrade_ShortValue,
ClCoaT.SHORTSTRINGVALUE as CoatingType_ShortValue
from CL_WasherType ClWT
JOIN JWasher JWa on (ClWT.VALUEID = JWa.WasherType)
JOIN JRteWasher RteW ON (RteW.Oid = JWa.Oid)
join JWasherSelectionFilter Wsf ON (Wsf.ContractorCommoditycode = JWa.IndustryCommoditycode)
join CL_GEOMETRICINDUSTRYSTANDARD ClGIS on (ClGIS.VALUEID= GeometricIndustryStandard)
join JGenericMaterialControlData JGMCD on (JGMCD.ContractorCommoditycode = JWa.IndustryCommoditycode)
join CL_MANUFACTURER ClMfd on (ClMfd.VALUEID = JGMCD.Manufacturer)
join CL_MATERIALSGRADE ClMGr on (ClMGr.VALUEID = JWa.MaterialsGrade)
join CL_CoatingType ClCoaT on (ClCoaT.VALUEID = JWa.CoatingType)
join XImpliedMatingParts Imp ON (Jwa.oid = Imp.oiddestination)
where Imp.oidOrigin= ?