Projects:Add IsExplodeConf in Characteristics/Technical Specifications

Introduction

In this document are described the developments needed to implement the is explode configuration tab.

Feature Request 30721

• Change the definition of the Characteristic Configuration tab to Standard.
• Add a DB Unique Index in the M_Product_Ch_Conf table for columns: M_Product_Ch_ID and M_Ch_Value_ID.

Feature Request 30724

• Add flag in M_Characteristic table.
  • Default Y.
• Add flag in M_Product_Ch table.
  • Default Y.
• Add flag in Product Characteristic window header.
  • Visible when Is Variant is checked.
  • Visible in grid, Is Variant also visible if it isn't.
  • The flag must be the next in sequence to the is variant flag.
• Add flag in Product window tab Characteristic.
  • Visible when Is Variant is checked and the product is generic.
  • Visible in grid, Is Variant also visible if it isn't.
  • Modify SL_ProductCh_Characteristic callout when the Characteristic is changed the value of the flag is updated with the status in the characteristic definition.
  • The flag must be the next in sequence to the is variant flag.
• Modify M_CH_VALUE_TRG trigger in M_Ch_Value to disable the insert based on the flag.
• Modify M_CH_SUBSET_VALUE_TRG trigger in M_Ch_Subset_Value to disable the insert based on the flag.
• Modify ProductCharacteristicEventHandler event handler to disable the insert based on the flag.

Feature Request 30726

• Modify the method that assigns the Characteristics to the products to set the value of the flag based on the value defined in the Characteristic.
• Create a new method to be called when a variant value is set. This method has to check if the corresponding value in the M_Product_Ch_Conf table exists. It has to create it and if exists set it as active.
• Create a new version of the module and publish it when previous feature requests are included in a MP.