Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Filters dimension group for Kit products.
Syntax
client server public static void FilterDimensionGroupForKit(Query filterDimGrpQuery)
Run On
Called
Parameters
- filterDimGrpQuery
Type: Query Class
The Dimension Group Query.
Remarks
The query is functionaly equivelent to the following logic select from ecoResProductDimensionGroup exists join ecoResProductDimensionGroupFldSetupExists where ecoResProductDimensionGroupFldSetupExists.productdimensiongroup == ecoResProductDimensionGroup.recid AND ecoResProductDimensionGroupFldSetupExists.isactive == NoYes::Yes AND ecoResProductDimensionGroupFldSetupExists.dimensionfieldid == fieldnum(InventDim, ConfigId) notexists join ecoResProductDimensionGroupFldSetupNotExists where ecoResProductDimensionGroupFldSetupNotExists.productdimensiongroup == ecoResProductDimensionGroup.recid AND ecoResProductDimensionGroupFldSetupNotExists.isactive == NoYes::Yes AND ecoResProductDimensionGroupFldSetupNotExists.dimensionfieldid != fieldnum(InventDim, ConfigId)