Nuts 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: Nuts Label
Description: Material Description Label for Nuts
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 JNut.NutType_ShortValue,
RteN.NutQuantity,
JNut.NutHeight,
JNSF.BoltDiameter,
JNut.GeometricIndustryStandard_ShortValue as GeomIndStandard_ShortValue, JGMCD.Manufacturer_ShortValue,
JNut.MaterialsGrade_ShortValue,
JNut.CoatingType_ShortValue from dbo.JNut_CL JNut
join JNUtselectionFilter JNSF ON (JNSF.ContractorCommoditycode = JNut.IndustryCommoditycode)
join XImpliedMatingParts Imp ON (JNut.oid = Imp.oiddestination)
join dbo.JRteNut RteN ON (Imp.oidOrigin = RteN.Oid)
join dbo.JGenericMaterialControlData_CL JGMCD on (JGMCD.ContractorCommoditycode = JNut.IndustryCommoditycode)
where Imp.oidOrigin=?

Select distinct ClNutT.SHORTSTRINGVALUE as NutType_ShortValue,
JNut.NutHeight,
JNSF.BoltDiameter,
ClGIS.SHORTSTRINGVALUE as GeomIndStandard_ShortValue, ClMfd.SHORTSTRINGVALUE as Manufacturer_ShortValue,
ClMGr.SHORTSTRINGVALUE as MaterialsGrade_ShortValue,
ClCoaT.SHORTSTRINGVALUE as CoatingType_ShortValue
from CL_NutType ClNutT
join JNut JNut on (ClNutT.VALUEID = Jnut.NutType)
join CL_GEOMETRICINDUSTRYSTANDARD ClGIS on (ClGIS.VALUEID= JNut.GeometricIndustryStandard)
join JGenericMaterialControlData JGMCD on (JGMCD.ContractorCommoditycode = JNut.IndustryCommoditycode)
join CL_MANUFACTURER ClMfd on (ClMfd.VALUEID = JGMCD.Manufacturer)
join CL_MATERIALSGRADE ClMGr on (ClMGr.VALUEID = JNut.MaterialsGrade)
join CL_CoatingType ClCoaT on (ClCoaT.VALUEID = JNut.CoatingType)
join JNUtselectionFilter JNSF ON (JNSF.ContractorCommoditycode = JNut.IndustryCommoditycode)
join XImpliedMatingParts Imp ON (JNut.oid = Imp.oiddestination)
where Imp.oidOrigin=?